I have a big orc table :
1) i have deleted the hdfs location
2) delete from table_name where dt=201611
3) insert into table_name partition(dt) select * from table2 where dt=201611;
then ORC count was double ,
i have tried with a) delete from table then also its showing same count
ANALYZE TABLE table_name PARTITION(dt) COMPUTE STATISTICS;
1/ does this command update hive metastore ?
2/ is this hive metastore issue ? if yes then how to solve this?
3/ msck repair table table_name :ERROR
"FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask"
What do you mean by "then ORC count was double"? Can you share all the commands you used for step #1, as well as the table schema?