[HIVE-4350] support AS keyword for table alias

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0, 0.11.0
• Fix Version/s: 0.12.0
• Component/s: SQL
• Release Note: Support AS keyword for table alias.
• Assignee: Matthew Weaver
• Reporter: Thejas Nair
• Created: 12/Apr/13 18:29
• Updated: 15/Oct/13 23:30
• Resolved: 30/Apr/13 06:20

Description

SQL standard supports AS optional keyword, while creating an table alias.

http://savage.net.au/SQL/sql-92.bnf.html#table reference

Hive gives a error when the optional keyword is used -
select * from tiny as t1;
org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: ParseException line 1:19 mismatched input 'as' expecting EOF near 'tiny'