Hive BDR Replication Fails | IllegalStateException: OTHER_ERROR

0 votes
2 views
asked Aug 30, 2017 in Hadoop by admin (4,410 points)
SummaryHive BDR Replication fails and the IllegalStateException / OTHER_ERROR happens if a view on source table has a managed table with the same name on the target cluster. Resolution is to drop the managed table or external table on the target that has the same name as a table view on the source before Hive BDR Replication job starts.

Symptoms

Hive BDR Replication fails with OTHER_ERROR in stderr.log of Metastore Import step.
Here is the stack trace of the error:

java.lang.IllegalStateException
	at com.google.common.base.Preconditions.checkState(Preconditions.java:129)
	at com.cloudera.enterprise.chive.Importer.handleTable(Importer.java:576)
	at com.cloudera.enterprise.chive.Importer.execute(Importer.java:113)
	at com.cloudera.enterprise.chive.Main$1.run(Main.java:31)
	at java.lang.Thread.run(Thread.java:745)
Errors were detected:
java.lang.IllegalStateException
Error detected: OTHER_ERROR
Error, exit with 1.
Add Link

Applies To
Cause

The IllegalStateException / OTHER_ERROR happens if a view on source  table has a  managed or external table with the same name on the target cluster. 

Instructions

Drop the managed table on the target that has the same name as a table view on the source before Hive BDR Replication job starts.

To find the names of table views on the source cluster, query the Hive Metastore Database using this sample query:

select DBS.NAME, TBL_NAME from SOURCE_DB.DBS JOIN SOURCE_DB.TBLS ON (DBS.DB_ID=TBLS.DB_ID) where TBL_TYPE = 'VIRTUAL_VIEW' AND DBS.NAME IN ('<Name of Hive DB in BDR Schedule>');


To find names of managed or external tables on the target cluster, query the Hive Metastore Database using this sample query:

select DBS.NAME, TBL_NAME from TARGET_DB.DBS JOIN TARGET_DB.TBLS ON (DBS.DB_ID=TBLS.DB_ID) 

Please log in or register to answer this question.

...