If you are using Drill 0.7 & 0.8 upgrade to Hive 0.13. —Andries
On Jan 6, 2015, at 2:41 AM, LIU Xiaobing <[email protected]> wrote: > 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 刘小兵
