You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Venki Korukanti (JIRA)" <ji...@apache.org> on 2014/05/15 03:06:14 UTC
[jira] [Commented] (DRILL-737) describe command fails to work with
hive tables in default database
[ https://issues.apache.org/jira/browse/DRILL-737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13998349#comment-13998349 ]
Venki Korukanti commented on DRILL-737:
---------------------------------------
default is a keyword. Put that in backticks to avoid parser error.
{code}
describe hive.`default`.t1
{code}
> describe command fails to work with hive tables in default database
> -------------------------------------------------------------------
>
> Key: DRILL-737
> URL: https://issues.apache.org/jira/browse/DRILL-737
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Rahul Challapalli
> Attachments: doctors.avsc, doctors.ddl
>
>
> From hive :
> create table t1 (col1 string);
> From Drill :
> describe hive.t1;
> +--+
> | |
> +--+
> +--+
> describe hive.default.t1;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "a26fe2d9-af59-49c3-a686-871207a90681"
> endpoint {
> address: "qa-node190.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < SqlParseException:[ Encountered ". default" at line 1, column 14.
> Was expecting one of:
> <EOF>
> <IDENTIFIER> ...
> <QUOTED_IDENTIFIER> ...
> <BACK_QUOTED_IDENTIFIER> ...
> <BRACKET_QUOTED_IDENTIFIER> ...
> <UNICODE_QUOTED_IDENTIFIER> ...
> <BINARY_STRING_LITERAL> ...
> <PREFIXED_STRING_LITERAL> ...
> <QUOTED_STRING> ...
> <UNICODE_STRING_LITERAL> ...
> "." <IDENTIFIER> ...
> "." <QUOTED_IDENTIFIER> ...
> "." <BACK_QUOTED_IDENTIFIER> ...
> "." <BRACKET_QUOTED_IDENTIFIER> ...
> "." <UNICODE_QUOTED_IDENTIFIER> ...
> ]"
> ]
> Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)