Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-35673

Spark fails on unrecognized hint in subquery

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.2, 3.1.1, 3.1.2, 3.2.0
    • Fix Version/s: 3.0.3, 3.2.0, 3.1.3
    • Component/s: SQL
    • Labels:
      None

      Description

      Spark queries to fail on unrecognized hints in subqueries. An example to reproduce:

      SELECT /*+ use_hash */ 42;
      -- 21/06/08 01:28:05 WARN HintErrorLogger: Unrecognized hint: use_hash()
      -- 42
      
      SELECT *
      FROM (
          SELECT /*+ use_hash */ 42
      );
      -- 21/06/08 01:28:07 WARN HintErrorLogger: Unrecognized hint: use_hash()
      -- Error in query: unresolved operator 'Project [*];
      -- 'Project [*]
      -- +- SubqueryAlias __auto_generated_subquery_name
      --    +- Project [42 AS 42#2]
      --       +- OneRowRelation
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fchen Fu Chen
                Reporter:
                rshkv Willi Raschkowski
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: