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

Randomly generated query fails with "Expressions in the ORDER BY clause must not be constant"

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: Impala 2.3.0
    • Fix Version/s: None
    • Component/s: Infrastructure

      Description

      A query generated for the stress test failed with the following error:

      12:48:07 SELECT
      12:48:07 IF(t2.boolean_col_1, t2.int_col_2, t1.int_col_2) AS int_col,
      12:48:07 COALESCE(t1.int_col_2, t2.int_col_2, t2.int_col_2) AS int_col_1
      12:48:07 FROM table_1 t1
      12:48:07 INNER JOIN table_1 t2 ON ((t2.varchar0056_col_3) = (t1.varchar0056_col_3)) AND ((t2.decimal1802_col_4) = (t1.decimal1802_col_4))
      12:48:07 Traceback (most recent call last):
      12:48:07   File "tests/stress/concurrent_select.py", line 922, in populate_runtime_info_for_random_queries
      12:48:07     timeout_secs=query_timeout_secs)
      12:48:07   File "tests/stress/concurrent_select.py", line 1022, in populate_runtime_info
      12:48:07     report = get_report()
      12:48:07   File "tests/stress/concurrent_select.py", line 981, in get_report
      12:48:07     raise QueryTimeout()
      12:48:07 QueryTimeout
      12:48:07 12:48:07 13604 140202811352832 INFO:concurrent_select[944]:Collecting runtime info for query: 
      12:48:07 SELECT
      12:48:07 t1.float_col_6,
      12:48:07 (-161) IN (-60, -872) AS boolean_col,
      12:48:07 (LEAD((866) - (864.9960081188), 36) OVER (ORDER BY t1.float_col_6 DESC, (-161) IN (-60, -872) DESC)) + (-545) AS decimal_col
      12:48:07 FROM table_30 t1
      12:48:07 WHERE
      12:48:07 (314) NOT IN (157, -560)
      12:48:08 12:48:08 13604 140202811352832 WARNING:concurrent_select[930]:Error running query (the test will continue)
      12:48:08 AnalysisException: Expressions in the ORDER BY clause must not be constant: (-161) IN (-60, -872) (in (lead((866) - (864.9960081188), 36) OVER (ORDER BY t1.float_col_6 DESC, (-161) IN (-60, -872) DESC)))
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                tarmstrong Tim Armstrong
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: