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