[HIVE-6617] Reduce ambiguity in grammar

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0, 1.0.0, 1.1.0
• Fix Version/s: 1.2.0
• Component/s: Parser
• Labels: TODOC1.2
• Hadoop Flags: Incompatible change, Reviewed

Release Note

SQL distinguishes between reserved and non-reserved keywords. We reserved 74 key words in this patch according to the SQL2011 standard. There are two ways if the user still would like to use the reserved keywords as identifiers, (1) Use quoted identifiers (2) set hive.support.sql11.reserved.keywords=false;

• Assignee: Pengcheng Xiong
• Reporter: Ashutosh Chauhan
• Created: 11/Mar/14 17:55
• Updated: 31/Oct/17 17:55
• Resolved: 10/Mar/15 22:11

Description

CLEAR LIBRARY CACHE

As of today, antlr reports 214 warnings. Need to bring down this number, ideally to 0.

Issue Links

• is related to: HIVE-14872 Remove the configuration HIVE_SUPPORT_SQL11_RESERVED_KEYWORDS
• is related to: HIVE-3439 PARTITIONED BY clause in CREATE TABLE is order-dependent
• is related to: HIVE-3798 Can't escape reserved keywords used as table names
• is related to: HIVE-7178 Table alias cannot be used in GROUPING SETS clause if there are more than one column in it
• is related to: HIVE-6950 Parsing Error in GROUPING SETS
• is related to: HIVE-4067 Followup to HIVE-701: reduce ambiguity in grammar
• is related to: HIVE-701 lots of reserved keywords in hive
• relates to: HIVE-9433 select DB.TABLE.* will fail
• relates to: HIVE-9840 select count(*) <tablename> should give exception
• relates to: HIVE-12474 ORDER BY should handle column refs in parantheses
• relates to: HIVE-12156 expanding view doesn't quote reserved keyword
• relates to: IMPALA-3916 Reserve SQL:2016 keywords
• links to: RB