Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)
Rising Star

Problem description :

When upgrading to HDP 2.5.3 , some queries to Hive were failing Especially when executing Insert Overwrite queries. with the following error :

ERROR : Failed with exception java.util.ConcurrentModificationException org.apache.hadoop.hive.ql.metadata.HiveException: java.util.ConcurrentModificationException at org.apache.hadoop.hive.ql.metadata.Hive.moveFile(Hive.java:2883) at ..... etc

Caused by: java.util.ConcurrentModificationException

Workaround:

"Add SORT BY 0" to your query.

INSERT OVERWRITE TABLE AAA SELECT A , B , C FROM BBBB SORT BY 0 ;

More investigations to follow up ...

1,067 Views
0 Kudos
Comments

This is a KB at most. It is not even complete. Just read "More investigations to follow up ..."

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎01-20-2017 04:06 PM
Updated by:
 
Contributors
Top Kudoed Authors