• 1 reply
  • Latest Post - ‏2013-12-12T07:07:17Z by mrmadira
11 Posts

Pinned topic Count(*) in Hive

‏2013-12-11T16:23:25Z | bigdata biginsights bigsheets count hive ibm table

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? 

  • mrmadira
    26 Posts

    Re: Count(*) in Hive


    Sounds to me that the problem could be that the line delimiter (new line or \n) is not consistent within your original data.