question hive count(*) not working in Support Questions

question hive count(*) not working in Support Questions https://community.cloudera.com/t5/Support-Questions/hive-count-not-working/m-p/216889#M178798 <P>i have a table with 1 million rows and i can select from it but when i try count(*) from hive it shows 0 rows ?</P><PRE>hive> select txn_id,msg_id from pa_lane_txn limit 10; OK 19651715642 PRKG 19651715644 TTOL 19651715646 ETKT 19651715648 TTOL 19651715650 TTOL 19651715654 XTKT 19651715656 XTKT 19651715658 TTOL 19651715660 TTOL 19651715662 TTOL Time taken: 0.142 seconds, Fetched: 10 row(s) hive> select count(*) from pa_lane_txn; OK 0 Time taken: 0.083 seconds, Fetched: 1 row(s) hive> </PRE> Wed, 28 Jun 2017 04:25:00 GMT aliyesami 2017-06-28T04:25:00Z