Hive query getting failed while trying to use TEZ engine

Question

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.

Your help is appreciated.

Please include the full stacktrace as text, not an image – OneCricketeer Jan 02 '20 at 06:34 — OneCricketeer, Jan 02 '20 at 06:34

score 0 · Answer 1 · answered Jan 30 '20 at 14:36

0

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

answered Jan 30 '20 at 14:36

jsoldera

13
1
5

This is not an answer, this is a comment. Consider using the comments feature underneath the question. – pbarill Jan 30 '20 at 15:19

score 0 · Answer 2 · answered Jan 30 '20 at 15:38

0

Probably you might be hitting TEZ-2741.

can you try to run the query by setting below config

hive.compute.splits.in.am=false

answered Jan 30 '20 at 15:38

Putti

37
4

score 0 · Answer 3 · answered Feb 03 '20 at 12:38

0

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

answered Feb 03 '20 at 12:38

Sourav Chatterjee

159
2
15

Hive query getting failed while trying to use TEZ engine

3 Answers3