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

Spark fails on unrecognized hint in subquery

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.2, 3.1.1, 3.1.2, 3.2.0
    • 3.0.3, 3.2.0, 3.1.3
    • SQL
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment