Thejas M Nair created HIVE-4350: ----------------------------------- Summary: support AS keyword for table alias Key: HIVE-4350 URL: https://issues.apache.org/jira/browse/HIVE-4350 Project: Hive Issue Type: Bug Components: SQL Affects Versions: 0.10.0 Reporter: Thejas M Nair
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' -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira