Hi
My hive storage plugin is working and I can see the hive tables but I can’t
select from them ,please advise
apache drill (hive.default)> show tables;
+--------------+------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------+
| hive.default | test |
+--------------+------------+
1 row selected (0.126 seconds)
apache drill (hive.default)> select id from hive.default.`test`;
Error: PARSE ERROR: Encountered ". default" at line 1, column 20.
Was expecting one of:
<EOF>
"ORDER" ...
"LIMIT" ...
"OFFSET" ...
"FETCH" ...
"NATURAL" ...
"JOIN" ...
"INNER" ...
"LEFT" ...
"RIGHT" ...
"FULL" ...
"CROSS" ...
"," ...
"OUTER" ...
"(" ...
"MATCH_RECOGNIZE" ...
"." ...
<IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<UNICODE_QUOTED_IDENTIFIER> ...
"TABLESAMPLE" ...
"WHERE" ...
"GROUP" ...
"HAVING" ...
"WINDOW" ...
"UNION" ...
"INTERSECT" ...
"EXCEPT" ...
"MINUS" ...
"." <IDENTIFIER> ...
"." <QUOTED_IDENTIFIER> ...
"." <BACK_QUOTED_IDENTIFIER> ...
"." <BRACKET_QUOTED_IDENTIFIER> ...
"." <UNICODE_QUOTED_IDENTIFIER> ...
"." "*" ...
"[" ...
SQL Query select id from hive.default.`test`
^
[Error Id: 96ad1704-8b95-42b7-913c-b62d3d2c5782 ] (state=,code=0)
apache drill (hive.default)>
