You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Huang Fan (武汉_技术部_搜索与精准化_广告部_黄凡)" <hu...@yhd.com> on 2015/06/04 08:02:14 UTC

looking for help about query error

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

Re: looking for help about query error

Posted by Rajkumar Singh <rs...@maprtech.com>.
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(武汉_技术部_搜索与精准化_广告部_黄凡) <hu...@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