[DRILL-790] A query to an empty Hive table never returns from sqlline

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Storage - Hive
• Assignee: Venki Korukanti
• Reporter: George Chow
• Created: 20/May/14 18:49
• Updated: 12/Jun/14 16:47
• Resolved: 12/Jun/14 16:47

Description

Consider an empty table in Hive as follows:

hive> describe string_table;
OK
keycolumn               string                  None
column1                 string                  None
Time taken: 2.025 seconds, Fetched: 2 row(s)
hive> select * from string_table;
OK
Time taken: 0.409 seconds

Querying this table from sqlline never returns:

0: jdbc:drill:local=192.168.39.43:31010> describe hive.`default`.string_table;
+-------------+------------+-------------+
| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
+-------------+------------+-------------+
| keycolumn   | VARCHAR    | NO          |
| column1     | VARCHAR    | NO          |
+-------------+------------+-------------+
2 rows selected (1.413 seconds)
0: jdbc:drill:local=192.168.39.43:31010> select * from  hive.`default`.string_table;
<never returns>