Hi Huang Please use select * from hive.`match`.yyyTable limit 10, for q2 ensure the read permission on the external table.
Thanks Rajkumar Singh MapR Technologies > On Jun 4, 2015, at 11:32 AM, Huang Fan(武汉_技术部_搜索与精准化_广告部_黄凡) > <[email protected]> wrote: > > 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
