02-13-2019 02:39 AM - last edited on 02-13-2019 06:13 AM by cjervis
We have taken backup one of the production database data and moved it to development local filesystem.
In development movied data from local mountpoint to hive database hdfs location.
Question1: Hive msck repair in managed partition table failed with below error message.
hive> msck repair table testsb.xxx_bk1;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
What does exception means.
After dropping the table and re-create the table in external type. it worked successfully.
hive> use testsb;
Time taken: 0.032 seconds
hive> msck repair table XXX_bk1;
Repair: Added partition to metastore xxx_bk1:payloc=0002/client_key=MISSDC/trxdate=20110105
Time taken: 16347.793 seconds, Fetched: 94156 row(s)
Can you please confirm why it not worked in managed table?
Question:2. Where else select * from table; query able to fetch in non-partition table. Why?
We have done testsb database creation and Table creation with ddl script.
And moved the data from local to hdfs hive table location.
02-21-2019 11:49 AM
In non-partition table having multiple files in table location. When select statement triggered it worked.
How it fetch the data where else without running msck repair command?