[HIVE-729] select expression with optional "as"

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Zheng Shao
• Reporter: Zheng Shao
• Created: 06/Aug/09 04:20
• Updated: 17/Dec/11 00:07
• Resolved: 06/Aug/09 22:58

Description

"as" should be optional in select expression. Query like the following should work:

SELECT a, b FROM (
  SELECT key a, value b
  FROM src
) src1
ORDER BY a LIMIT 1;

Issue Links

• is depended upon by: HIVE-187 ODBC driver