[
https://issues.apache.org/jira/browse/FLINK-16422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051250#comment-17051250
]
Leonard Xu commented on FLINK-16422:
------------------------------------
Hi, [~gyfora]
Thanks for your reports, This should not a bug, default is a keyword in Flink
SQL, try to escape it as following:
{code:java}
select * from hive.`default`.itemtransactions;
{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)
