Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.0.0
-
None
Description
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 |
--------------------------------------