[IMPALA-1958] Impala doesn't support reuse of previous expression values in subsequent part of select query

• Type: New Feature
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 2.1
• Component/s: Frontend
• Labels: sql-language
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Krishna Sangeeth
• Created: 20/Apr/15 11:45
• Updated: 09/Aug/16 19:54

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'