[
https://issues.apache.org/jira/browse/FLINK-16422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17052103#comment-17052103
]
Leonard Xu edited comment on FLINK-16422 at 3/5/20, 12:54 PM:
--------------------------------------------------------------
[~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]
was (Author: leonard xu):
[~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)
