You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Venki Korukanti (JIRA)" <ji...@apache.org> on 2015/05/29 18:45:17 UTC
[jira] [Updated] (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:all-tabpanel ]
Venki Korukanti updated DRILL-3215:
-----------------------------------
Attachment: DRILL-3215-1.patch
> 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)