Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-8103

Plan hints show up as "--" comments in analysed query

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Impala 3.2.0
    • Component/s: Frontend
    • Labels:
      None

      Description

      I noticed that the hints added in IMPALA-5821 show up in the – style rather than /**/

          Sql Statement: select * from tpch.lineitem join /*+ broadcast */ tpch.part on l_partkey = p_partkey limit 
      ...
      Analyzed query: SELECT * FROM tpch.lineitem INNER JOIN
      -- +broadcast
      tpch.part ON l_partkey = p_partkey LIMIT CAST(5 AS TINYINT)
      

      I guess this works and maybe its fine, but I was really confused when I saw it. It looks like getPlanHintsSql() uses this to generate views in such a way that Hive will ignore the hints, but that concern doesn't seem relevant to this use case.

        Attachments

          Activity

            People

            • Assignee:
              asherman Andrew Sherman
              Reporter:
              tarmstrong Tim Armstrong
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: