Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Unable to Insert all the Data in a Partitioned Table - Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception when loading 334 partitions in table

avatar
New Contributor

I'm trying to insert data into a partitioned table. However, after some data inserted successfully, arise an exception:

The partitioned field is a date format (2021-01-26).

 

Even more, the error change in some cases:

E.g. for some data the Exception is:

Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception when loading 334 partitions in table data_wview_release with loadPath=hdfs://haprod/warehouse/tablespace/managed/hive/datam.db/data_w

 

And for other data the Exception is: 

Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Exception updating metastore for acid table datam.data_autorizaciones_wview_release with partitions [data_wview_release(fc_dia=2021-06-24), data_wview_release(fc_dia=2021-06-14),

 

Any idea how to fix it?

 

Thanks

 

1 REPLY 1

avatar
Cloudera Employee

can we have complete error stack trace or hs2 logs and version details for reference?