[ https://issues.apache.org/jira/browse/FLINK-16422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17052103#comment-17052103 ]
Leonard Xu commented on FLINK-16422: ------------------------------------ [~gyfora] I got it, SQL CLI should return : {code:java} Flink SQL> select * FROM myhive.^ myhive.`default`.user_info myhive.`default`.user_info {code} instead of : {code:java} Flink SQL> select * FROM myhive.^ myhive.default.user_info myhive.default.user_info {code} when user press tab for autocomplete. The reason should be planner missed escaping keywords when get completion hints. refers: `FlinkPlannerImpl.getCompletionHints(sql: String, cursor: Int)`. CC: [~danny0405] > Cannot use [catalog].[db].table with Hive catalog > ------------------------------------------------- > > Key: FLINK-16422 > URL: https://issues.apache.org/jira/browse/FLINK-16422 > Project: Flink > Issue Type: Bug > Components: Connectors / Hive, Table SQL / Client > Affects Versions: 1.10.0 > Reporter: Gyula Fora > Priority: Major > > When trying to select a table from the Hive , the SQL CLI automcompletes to > the full table name: > select * from hive.default.itemtransactions ; > but then we get the following error: > [ERROR] Could not execute SQL statement. Reason: > org.apache.flink.table.api.SqlParserException: SQL parse failed. Encountered > ". default" at line 1, column 19. > Was expecting one of:... -- This message was sent by Atlassian Jira (v8.3.4#803005)