[ https://issues.apache.org/jira/browse/FLINK-35221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wencong Liu updated FLINK-35221: -------------------------------- Description: According to Hive user documentation[1], starting from version 0.13.0, Hive prohibits the use of reserved keywords as identifiers. Moreover, versions 2.1.0 and earlier allow using SQL11 reserved keywords as identifiers by setting {{hive.support.sql11.reserved.keywords=false}} in hive-site.xml. This compatibility feature facilitates jobs that utilize keywords as identifiers. HiveParser in Flink, relying on Hive version 2.3.9, lacks the option to treat SQL11 reserved keywords as identifiers. This poses a challenge for users migrating SQL from Hive 1.x to Flink SQL, as they might encounter scenarios where keywords are used as identifiers. Addressing this issue is necessary to support such cases. [1] [LanguageManual DDL - Apache Hive - Apache Software Foundation|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL] was: According to Hive user documentation[1], starting from version 0.13.0, Hive prohibits the use of reserved keywords as identifiers. Moreover, versions 2.1.0 and earlier allow using SQL11 reserved keywords as identifiers by setting {{hive.support.sql11.reserved.keywords=false}} in hive-site.xml. This compatibility feature facilitates jobs that utilize keywords as identifiers. HiveParser in Flink, relying on Hive version 2.3.9, lacks the option to treat SQL11 reserved keywords as identifiers. This poses a challenge for users migrating SQL from Hive 1.x to Flink SQL, as they might encounter scenarios where keywords are used as identifiers. Addressing this issue is necessary to support such cases. > Support SQL 2011 reserved keywords as identifiers in Flink HiveParser > ---------------------------------------------------------------------- > > Key: FLINK-35221 > URL: https://issues.apache.org/jira/browse/FLINK-35221 > Project: Flink > Issue Type: Improvement > Components: Connectors / Hive > Affects Versions: 1.20.0 > Reporter: Wencong Liu > Priority: Major > > According to Hive user documentation[1], starting from version 0.13.0, Hive > prohibits the use of reserved keywords as identifiers. Moreover, versions > 2.1.0 and earlier allow using SQL11 reserved keywords as identifiers by > setting {{hive.support.sql11.reserved.keywords=false}} in hive-site.xml. This > compatibility feature facilitates jobs that utilize keywords as identifiers. > HiveParser in Flink, relying on Hive version 2.3.9, lacks the option to treat > SQL11 reserved keywords as identifiers. This poses a challenge for users > migrating SQL from Hive 1.x to Flink SQL, as they might encounter scenarios > where keywords are used as identifiers. Addressing this issue is necessary to > support such cases. > [1] [LanguageManual DDL - Apache Hive - Apache Software > Foundation|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL] -- This message was sent by Atlassian Jira (v8.20.10#820010)