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

Pinned topic Count(*) in Hive

‏2013-12-11T16:23:25Z |

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
    mrmadira
    26 Posts

    Re: Count(*) in Hive

    ‏2013-12-12T07:07:17Z  

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