[ 
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)

Reply via email to