[ https://issues.apache.org/jira/browse/HIVE-4350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-4350: ------------------------------ Attachment: HIVE-4350.D10503.3.patch mweaverh updated the revision "HIVE-4350 [jira] support AS keyword for table alias". Deleted additional test query, just added AS to an existing query. Reviewers: JIRA REVISION DETAIL https://reviews.facebook.net/D10503 CHANGE SINCE LAST DIFF https://reviews.facebook.net/D10503?vs=32799&id=32811#toc AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/parse/FromClauseParser.g ql/src/test/queries/clientpositive/input4.q ql/src/test/results/clientpositive/input4.q.out To: JIRA, mweaverh Cc: thejas > 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 > Assignee: Matthew Weaver > Attachments: HIVE-4350.D10503.1.patch, HIVE-4350.D10503.2.patch, > HIVE-4350.D10503.3.patch > > > 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