Hi All,   I have migrated a hive table from one cluster to another cluster. I have exported table to hdfs first, then moved it to another cluster and imported to hive. While doing that i have used below commands :   hive -e "EXPORT TABLE <dbname>.<tablename> TO 'hdfs://<cluster-1-active-namenode-IP>:8020/tmp/export_<tablename>/';" > <tablename>.log hadoop distcp hdfs://<cluster-1-active-namenode-IP>:8020/tmp/export_<tablename>/ hdfs://<cluster-2-active-namenode-IP>:8020/tmp/export_<tablename>/ > export_<tablename>.log IMPORT TABLE <dbname>.<tablename> FROM 'hdfs://<cluster-2-active-namenode-IP>:8020/tmp/export_<tablename>/';   After moving this table to hive in new cluster, i have created a new table and inserted all table data to a new table like below :   insert into table <new_tablename> select * from <tablename>;   For example, below command returns approximately 234 millions as row count :   select count(*) from <tablename>;   However below commands only 42 millions as row count :   select count(*) from <new_tablename>;     What could be the cause of this problem? ... View more