You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by LIU Xiaobing <lx...@gmail.com> on 2015/01/06 11:39:50 UTC

drill connect hive problem

Hi all,
I am new to drill. I have installed drill in embedded mode. And I have
successfully query hdfs files according the wiki. But the error came out
when i quering hive-0.12.0 using drill.

*0: jdbc:drill:schema=myhive:zk=local> SELECT firstname,lastname FROM
myhive.`customers` limit 10;*
*Query failed: Query failed: Unexpected exception during fragment
initialization: Internal error: Error while applying rule
DrillPushProjIntoScan, args
[rel#75:ProjectRel.NONE.ANY([]).[](child=rel#74:Subset#0.ENUMERABLE.ANY([]).[],firstname=$0,lastname=$1),
rel#66:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[myhive,
customers])]*

*Error: exception while executing query: Failure while executing query.
(state=,code=0)*
*0: jdbc:drill:schema=myhive:zk=local> *

I cann't find any useful information to analyze this problem. Ask for help!

By the way, when i build drill-0.8.0-SNAPSHOT from github, the query won't
give any result but just get stuck.

-- 
Best Regards
LIU Xiaobing 刘小兵