[DRILL-3215] Describe table from hive storage does not connect to "default" database

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.1.0
• Component/s: Storage - Hive
• Assignee: Venki Korukanti
• Reporter: Krystal
• Created: 29/May/15 15:50
• Updated: 14/Sep/15 23:43
• Resolved: 08/Jun/15 19:10

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

--------------------------------------