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"

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

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Won't Fix
    • Impala 2.3.0
    • None
    • 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

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

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment