[ 
https://issues.apache.org/jira/browse/FLINK-16422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051878#comment-17051878
 ] 

Leonard Xu commented on FLINK-16422:
------------------------------------

Hi, [~gyfora]  How the autocompletes happened in SQL CLI, I tried some commands 
but didn't reproduce it, could you paste your commands or code?
{code:java}
Flink SQL> show catalogs;
default_catalog
myhive
Flink SQL> use catalog myhive;
Flink SQL> select * from user_info; 
# the query work well, user_info is a hive table and its full path is 
myhive.default.user_info{code}

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

Reply via email to