Support Questions
Find answers, ask questions, and share your expertise

External ORC Table : count not Matches

External ORC Table : count not Matches

Explorer

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"

1 REPLY 1

Re: External ORC Table : count not Matches

Contributor

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?