Hive query getting failed while trying to use TEZ engine

0
votes

I am trying to execute the below query using the TEZ engine which got executed successfully in MR engine.

 set hive.execution.engine=tez;SET hive.exec.dynamic.partition = true; SET hive.exec.dynamic.partition.mode = nonstrict;SET hive.exec.compress.output=true;SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec; insert overwrite table df.test_table PARTITION (load_date1) SELECT * df.SRC_test_table lower(STATUS)<>lower('STATUS');

Below is the log for the same.

enter image description here

Your help is appreciated.

3
hadoophiveapache-tez
Please include the full stacktrace as text, not an image - OneCricketeer

3 Answers

0
votes

Sorry but isn't your FROM statement missing? And Where clause...

0
votes

Probably you might be hitting TEZ-2741.

can you try to run the query by setting below config

hive.compute.splits.in.am=false
0
votes

After a couple of hits and trails, I had found that ';' is a must thing for this new version.