Hive QL Tez engine error

Technical Discussions Hive
#1

Hi,

I am trying to insert into a table from the same table using INSERT INTO TABLE_NAME SELECT COLS1,COLS2… from TABLE_NAME(same); but am getting teh below error. please help me understand the below issue

Query ID = sivalala5932_20180630120839_255307fe-cab4-43e7-b45b-b018554668d6
Total jobs = 1
Launching Job 1 out of 1
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask

1 Like
#2

@siva,

It’s not so right approach to do. Because whenever Hive reads a table, it reads from first_row to last_row of table i.e. files in HDFS. Now you’re reading & inserting into same time it means, there is no starting & ending point of reading any data. It is kind of infinite loop. By the way use staging table & later merge staging to your table will solve issue.

3 Likes