I have imported a table into BigInsights using distributed copy import . On doing a select count(*) from Hive, I'm getting the row count as 788,339 and on converting the table into bigsheet then row count at the bottom is 859,589. But the actual count should be 859,591 rows. Why am I getting extra rows for this table in Hive and less when viewed in BigSheets?
Is there any other way of doing count(*) in bigSql?