S3 file is not equal upon counting in AWS athena

0

I have a file stored in S3 with a count of 33,09,1073. Upon counting it via query in AWS Athena the count is already 33,196,272 and we found out the excess rows are all blanks. We're trying to make it equal but delete command in AWS Athena is not working. Any suggestions how to remove the said extra blank rows??

Vanessa

Posted 2019-06-10T11:43:08.900

Reputation: 1

No answers