You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Mehant Baid (JIRA)" <ji...@apache.org> on 2015/06/03 19:06:38 UTC
[jira] [Commented] (DRILL-3215) Describe table from hive storage
does not connect to "default" database
[ https://issues.apache.org/jira/browse/DRILL-3215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14571329#comment-14571329 ]
Mehant Baid commented on DRILL-3215:
------------------------------------
+1
> Describe table from hive storage does not connect to "default" database
> -----------------------------------------------------------------------
>
> Key: DRILL-3215
> URL: https://issues.apache.org/jira/browse/DRILL-3215
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Hive
> Affects Versions: 1.0.0
> Reporter: Krystal
> Assignee: Venki Korukanti
> Attachments: DRILL-3215-1.patch
>
>
> From sqlline, I connect to a hive storage without specifying a database and issued a "describe <table>" command. Drill returned an empty result.
> 0: jdbc:drill:schema=dfs.root> use hive;
> +-------+-----------------------------------+
> | ok | summary |
> +-------+-----------------------------------+
> | true | Default schema changed to [hive] |
> +-------+-----------------------------------+
> 1 row selected (0.149 seconds)
> 0: jdbc:drill:schema=dfs.root> show tables;
> +---------------+------------------+
> | TABLE_SCHEMA | TABLE_NAME |
> +---------------+------------------+
> | hive.default | timestamp_table |
> | hive.default | varchar_table |
> | hive.default | voter_hive |
> | hive.default | voter_hive_p |
> +---------------+------------------+
> 0: jdbc:drill:schema=dfs.root> describe voter_hive;
> +--+
> | |
> +--+
> +--+
> I need to specify the database in the describe command for it to work:
> 0: jdbc:drill:schema=dfs.root> describe `hive.default`.voter_hive;
> +----------------+------------+--------------+
> | COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
> +----------------+------------+--------------+
> | voter_id | SMALLINT | YES |
> | name | VARCHAR | YES |
> | age | TINYINT | YES |
> | registration | VARCHAR | YES |
> | contributions | DECIMAL | YES |
> | voterzone | INTEGER | YES |
> | create_time | TIMESTAMP | YES |
> +----------------+------------+--------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)