Dear developers
Thank you for reading my letter.
Drill is great tool for query big data. But I got some problem on
query hive and hbase.
Sorry for my pool English, hope you can understand my questions.
Q1: (can not query in specific hive schema)
I have 2 schemas in hive, 1. pis 2. match when I search in drill web UI:
select * from hive.pis.xxxTable limit 10 it’s works fine.
But when I switch to the other schema : select * from hive.match.yyyTable
limit 10
I got this message :
org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR:
Encountered ". match" at line 1, column 19. Was expecting one of: "ORDER" ...
"LIMIT" ... "OFFSET" ... "FETCH" ... "NATURAL" ... "JOIN" ... "INNER" ...
"LEFT" ... "RIGHT" ... "FULL" ... "CROSS" ... "," ... "EXTEND" ... "(" ... "."
... "AS" ... ... ... ... ... ... "TABLESAMPLE" ... "WHERE" ... "GROUP" ...
"HAVING" ... "WINDOW" ... "UNION" ... "INTERSECT" ... "EXCEPT" ... "." ... "."
... "." ... "." ... "." ... "." "*" ... "[" ... [Error Id:
17098aa3-6267-488b-a15b-facb8bc34b94 on hadoop005:31010]
seems like “match” is a keyword.
Q2: (can not query hive mapping hbase external table)
I create some External hive tables mapping to hbase.
When I query these tables in drill , got this Message :
ClassNotFoundException: org.apache.hadoop.hbase.mapreduce.TableInputFormatBase
After put hbase-server-0.98.7-hadoop2.jar to jars/3rdpary/ there’s no error
message, but no result found either. (can get data in hive use same sql)
Drill 1.0.0
Hbase 0.98.7
Hive 0.13.1
Hadoop 2.3.0
Look forward for you suggestions.
Sincerely
Huang Fan
