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

Impala doesn't support reuse of previous expression values in subsequent part of select query

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: Impala 2.1
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:

      Description

      This is more of a feature request than an a bug. I hope you guys would consider this.

      A simple query statement like

      "select 1 as a,
      
                a+1 as b;"
      
      

      is supported in DB's like Netezza . It is a common way by which we write SQL code. This helps us in writing some otherwise complex logic pretty easily.

      When i try the same in Impala I get the following error message

      Query: select 1 as a,
      a+1 as b
      ERROR: AnalysisException: couldn't resolve column reference: 'a'

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kskrishnasangeeth_impala_c215 Krishna Sangeeth
            • Votes:
              3 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: