drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajkumar Singh <rsi...@maprtech.com>
Subject Re: looking for help about query error
Date Thu, 04 Jun 2015 06:54:27 GMT
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(武汉_技术部_搜索与精准化_广告部_黄凡)
<huangfan@yhd.com> 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


Mime
View raw message