You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2015/05/29 17:51:17 UTC
[jira] [Created] (DRILL-3215) Describe table from hive storage does
not connect to "default" database
Krystal created DRILL-3215:
------------------------------
Summary: 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
>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)