Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
boring-cyborg[bot] commented on PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#issuecomment-2128322457 Awesome work, congrats on your first merged pull request! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
luoyuxia merged PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
WencongLiu commented on PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#issuecomment-2126952619 It seems that the test is canceled. Could you help me trigger it again? @luoyuxia -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
WencongLiu commented on PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#issuecomment-2126933902 @luoyuxia I've updated the pull request. PTAL. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
WencongLiu commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1611568586 ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,223 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +import static org.assertj.core.api.Assertions.assertThatNoException; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ +class HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest { Review Comment: I have renamed it. ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,223 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +import static org.assertj.core.api.Assertions.assertThatNoException; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ Review Comment: Fixed. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
luoyuxia commented on PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#issuecomment-2120403078 > Thanks for the update, +1 for merging. > > It seems that the CI failure is unrelated, @luoyuxia could you please help confirming this? Yeah. I think the CI failure is unrelated. But I think we should first fix the CI failure before we merge it to avoid error diverge. Since the Ci failure is introudce by FLINK-29114. At first glance, I think we can fix it in this pr by the way. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
luoyuxia commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1594867337 ## flink-connector-hive/src/main/java/org/apache/flink/table/planner/delegation/hive/parse/HiveASTParser.g: ## @@ -721,6 +722,12 @@ import org.apache.flink.table.planner.delegation.hive.copy.HiveASTParseError; public void setHiveConf(Configuration hiveConf) { this.hiveConf = hiveConf; } + protected boolean useSQL11ReservedKeywordsForIdentifier() { +if(hiveConf==null){ + return false; +} +return !hiveConf.getBoolean(SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, true); Review Comment: nit: ```suggestion return hiveConf.getBoolean(SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, false); ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
luoyuxia commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1594867337 ## flink-connector-hive/src/main/java/org/apache/flink/table/planner/delegation/hive/parse/HiveASTParser.g: ## @@ -721,6 +722,12 @@ import org.apache.flink.table.planner.delegation.hive.copy.HiveASTParseError; public void setHiveConf(Configuration hiveConf) { this.hiveConf = hiveConf; } + protected boolean useSQL11ReservedKeywordsForIdentifier() { +if(hiveConf==null){ + return false; +} +return !hiveConf.getBoolean(SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, true); Review Comment: nit: ```suggestion return hiveConf.getBoolean(SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, false); ``` ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,223 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +import static org.assertj.core.api.Assertions.assertThatNoException; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ +class HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest { Review Comment: ```suggestion class HiveDialectSupportSQL11ReservedKeywordAsIdentifierITCase { ``` ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,223 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +import static org.assertj.core.api.Assertions.assertThatNoException; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ Review Comment: ```suggestion /** Test with SQL11 reserved keywords in hive queries. */ ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service,
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
WencongLiu commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1606184817 ## flink-connector-hive/src/main/java/org/apache/flink/table/planner/delegation/hive/HiveParserConstants.java: ## @@ -30,4 +30,6 @@ public class HiveParserConstants { /* Constants for insert overwrite directory */ public static final String IS_INSERT_DIRECTORY = "is-insert-directory"; public static final String IS_TO_LOCAL_DIRECTORY = "is-to-local-directory"; +public static final String SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME = Review Comment: I've renamed it to `HIVE_SUPPORT_SQL_11_RESERVED_KEYWORDS`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
WencongLiu commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1606184637 ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,230 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.configuration.BatchExecutionOptions; +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ +class HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest { +private static HiveCatalog hiveCatalog; +private static TableEnvironment tableEnv; +private static List sql11ReservedKeywords; + +@BeforeAll +static void setup() throws Exception { +hiveCatalog = HiveTestUtils.createHiveCatalog(); +hiveCatalog +.getHiveConf() +.setBoolean( +HiveParserConstants + .SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, +false); +hiveCatalog.open(); +tableEnv = getTableEnvWithHiveCatalog(); + tableEnv.getConfig().set(BatchExecutionOptions.ADAPTIVE_AUTO_PARALLELISM_ENABLED, false); Review Comment: This statement is unnecessary indeed. Removed. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
WencongLiu commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1606184227 ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,230 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.configuration.BatchExecutionOptions; +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ +class HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest { +private static HiveCatalog hiveCatalog; +private static TableEnvironment tableEnv; +private static List sql11ReservedKeywords; + +@BeforeAll +static void setup() throws Exception { +hiveCatalog = HiveTestUtils.createHiveCatalog(); +hiveCatalog +.getHiveConf() +.setBoolean( +HiveParserConstants + .SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, +false); +hiveCatalog.open(); +tableEnv = getTableEnvWithHiveCatalog(); + tableEnv.getConfig().set(BatchExecutionOptions.ADAPTIVE_AUTO_PARALLELISM_ENABLED, false); +sql11ReservedKeywords = +new ArrayList<>( +Arrays.asList( +"ALL", +"ALTER", +"ARRAY", +"AS", +"AUTHORIZATION", +"BETWEEN", +"BIGINT", +"BINARY", +"BOOLEAN", +"BOTH", +"BY", +"CREATE", +"CUBE", +"CURRENT_DATE", +"CURRENT_TIMESTAMP", +"CURSOR", +"DATE", +"DECIMAL", +"DELETE", +"DESCRIBE", +"DOUBLE", +"DROP", +"EXISTS", +"EXTERNAL", +"FALSE", +"FETCH", +"FLOAT", +"FOR", +"FULL", +"GRANT", +"GROUP", +"GROUPING", +"IMPORT", +"IN", +"INNER", +"INSERT", +"INT", +"INTERSECT", +"INTO", +"IS", +"LATERAL", +"LEFT", +"LIKE", +"LOCAL", +"NONE", +"NULL", +"OF", +"ORDER", +"OUT", +"OUTER", +"PARTITION", +
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
WencongLiu commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1606183796 ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,230 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.configuration.BatchExecutionOptions; +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ +class HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest { +private static HiveCatalog hiveCatalog; +private static TableEnvironment tableEnv; +private static List sql11ReservedKeywords; + +@BeforeAll +static void setup() throws Exception { +hiveCatalog = HiveTestUtils.createHiveCatalog(); +hiveCatalog +.getHiveConf() +.setBoolean( +HiveParserConstants + .SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, +false); +hiveCatalog.open(); +tableEnv = getTableEnvWithHiveCatalog(); + tableEnv.getConfig().set(BatchExecutionOptions.ADAPTIVE_AUTO_PARALLELISM_ENABLED, false); +sql11ReservedKeywords = +new ArrayList<>( +Arrays.asList( Review Comment: It's unnecessary indeed. Fixed. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
reswqa commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1602581492 ## flink-connector-hive/src/main/java/org/apache/flink/table/planner/delegation/hive/HiveParserConstants.java: ## @@ -30,4 +30,6 @@ public class HiveParserConstants { /* Constants for insert overwrite directory */ public static final String IS_INSERT_DIRECTORY = "is-insert-directory"; public static final String IS_TO_LOCAL_DIRECTORY = "is-to-local-directory"; +public static final String SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME = Review Comment: This name confused me indeed. It makes me think that this configuration option is used to control whether sql11 reserved keywords are allowed as identifier. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
reswqa commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1602576000 ## flink-connector-hive/src/main/java/org/apache/flink/table/planner/delegation/hive/HiveParserConstants.java: ## @@ -30,4 +30,6 @@ public class HiveParserConstants { /* Constants for insert overwrite directory */ public static final String IS_INSERT_DIRECTORY = "is-insert-directory"; public static final String IS_TO_LOCAL_DIRECTORY = "is-to-local-directory"; +public static final String SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME = Review Comment: ```suggestion public static final String SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS = ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
reswqa commented on code in PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#discussion_r1602571412 ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,230 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.configuration.BatchExecutionOptions; +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import org.apache.flink.util.CollectionUtil; + +import org.junit.jupiter.api.BeforeAll; +import org.junit.jupiter.api.Test; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.List; +import java.util.Random; + +/** Test the compatibility with SQL11 reserved keywords in hive queries. */ +class HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest { +private static HiveCatalog hiveCatalog; +private static TableEnvironment tableEnv; +private static List sql11ReservedKeywords; + +@BeforeAll +static void setup() throws Exception { +hiveCatalog = HiveTestUtils.createHiveCatalog(); +hiveCatalog +.getHiveConf() +.setBoolean( +HiveParserConstants + .SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME, +false); +hiveCatalog.open(); +tableEnv = getTableEnvWithHiveCatalog(); + tableEnv.getConfig().set(BatchExecutionOptions.ADAPTIVE_AUTO_PARALLELISM_ENABLED, false); +sql11ReservedKeywords = +new ArrayList<>( +Arrays.asList( Review Comment: Why we need the outer `new ArrayList<>`? ## flink-connector-hive/src/main/java/org/apache/flink/table/planner/delegation/hive/HiveParserConstants.java: ## @@ -30,4 +30,6 @@ public class HiveParserConstants { /* Constants for insert overwrite directory */ public static final String IS_INSERT_DIRECTORY = "is-insert-directory"; public static final String IS_TO_LOCAL_DIRECTORY = "is-to-local-directory"; +public static final String SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS_CONFIG_NAME = Review Comment: ```suggestion public static final String SUPPORT_SQL11_RESERVED_KEYWORDS_AS_IDENTIFIERS = ``` ## flink-connector-hive/src/test/java/org/apache/flink/connectors/hive/HiveDialectSupportSQL11ReservedKeywordAsIdentifierTest.java: ## @@ -0,0 +1,230 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.flink.connectors.hive; + +import org.apache.flink.configuration.BatchExecutionOptions; +import org.apache.flink.table.api.SqlDialect; +import org.apache.flink.table.api.TableEnvironment; +import org.apache.flink.table.catalog.hive.HiveCatalog; +import org.apache.flink.table.catalog.hive.HiveTestUtils; +import org.apache.flink.table.module.CoreModule; +import org.apache.flink.table.module.hive.HiveModule; +import org.apache.flink.table.planner.delegation.hive.HiveParserConstants; +import
Re: [PR] [FLINK-35221][hive] Support SQL 2011 reserved keywords as identifiers in HiveParser [flink-connector-hive]
boring-cyborg[bot] commented on PR #18: URL: https://github.com/apache/flink-connector-hive/pull/18#issuecomment-2081434598 Thanks for opening this pull request! Please check out our contributing guidelines. (https://flink.apache.org/contributing/how-to-contribute.html) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org