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

TEZ not returning result

TEZ not returning result

Explorer

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

LOGS:

Hiveserver2:

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

.....

Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)

Metastore :

INFO [pool-3-thread-154]: metastore.ObjectStore (ObjectStore.java:initialize(290)) - ObjectStore, initialize called 2016-08-29 02:22:30,010 WARN [pool-3-thread-154]: metastore.MetaStoreDirectSql (MetaStoreDirectSql.java:determineDbType(160)) - 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 (MetaStoreDirectSql.java:<init>(140)) - Using direct SQL, underlying DB is MYSQL 2016-08-29 02:22:30,017 INFO [pool-3-thread-154]: metastore.ObjectStore (ObjectStore.java:setConf(273)) - Initialized ObjectStore

1 REPLY 1

Re: TEZ not returning result

Explorer

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(GenTezUtils.java:408)