drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Huang Fan(武汉_技术部_搜索与精准化_广告部_黄凡) <huang...@yhd.com>
Subject looking for help about query error
Date Thu, 04 Jun 2015 06:02:14 GMT
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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message