Re: NPE org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable

2013-10-12 Thread xinyan Yang
thank you,I explain sql success,try hive trunk also success,but I do not know what patch fixed this problem 2013/10/11 Yin Huai > Hello Xinyang, > > Can you attach the query plan (the output of "EXPLAIN")? I think a bad > plan caused the error. > > Also, can you try hive trunk? Looks like it is

Re: NPE org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable

2013-10-11 Thread Yin Huai
Hello Xinyang, Can you attach the query plan (the output of "EXPLAIN")? I think a bad plan caused the error. Also, can you try hive trunk? Looks like it is a bug fixed after the release of 0.11. Thanks, Yin On Fri, Oct 11, 2013 at 9:21 AM, xinyan Yang wrote: > Development environment,hive 0

Re: NPE org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable

2013-10-11 Thread xinyan Yang
Development environment,hive 0.11、hadoop 1.0.3 2013/10/11 xinyan Yang > Hi, > when i run this sql,it fails,can anyone give me a advise > > > select e.udid as udid,e.a

NPE org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable

2013-10-11 Thread xinyan Yang
Hi, when i run this sql,it fails,can anyone give me a advise select e.udid as udid,e.app_id as app_id from acorn_3g.ClientChannelDefine cc join ( select udid,app_id,from_