Support Questions
Find answers, ask questions, and share your expertise

TEZ not returning result

TEZ not returning result


Query :

1) select x ,y,z form table_ORC_PARTAION limit 1000;

Result coming through TEZ engine

2) select business logic on table_ORC_PARTAION left join ........

Tez running successful but not no result. I ran same query on MR engine i am getting result ??? .

3) insert into table tabl1_ORC_PARTAION (dt=xxxx)

through tez showing 100 percent but nothing got inserted but through MR result got inserted



ver2.async.summary.multi_dest.batch.hdfs 2016-08-29 02:22:12,512 ERROR [HiveServer2-Handler-Pool: Thread-121308]: server.TThreadPoolServer ( - Error occurred during processing of message. java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Connection reset


Caused by: org.apache.thrift.transport.TTransportException: Connection reset at

Metastore :

INFO [pool-3-thread-154]: metastore.ObjectStore ( - ObjectStore, initialize called 2016-08-29 02:22:30,010 WARN [pool-3-thread-154]: metastore.MetaStoreDirectSql ( - DB Product name[MySQL] obtained, but not used to determine db type. Falling back to using SQL to determine which db we're using

INFO [pool-3-thread-154]: metastore.MetaStoreDirectSql (<init>(140)) - Using direct SQL, underlying DB is MYSQL 2016-08-29 02:22:30,017 INFO [pool-3-thread-154]: metastore.ObjectStore ( - Initialized ObjectStore


Re: TEZ not returning result


By using auto join false : hive shell get terminated with

Exception in thread "main" java.lang.AssertionError: No work found for tablescan TS[12] at org.apache.hadoop.hive.ql.parse.GenTezUtils.processAppMasterEvent(