Support Questions
Find answers, ask questions, and share your expertise

Hive ORC Table rows not matching with CSV file .

Hive ORC Table rows not matching with CSV file .

Super Collaborator

Hi ,

I am pointing my temporary table to a CSV file and loading into ORC from Temp table using INSERT..SELECT SQL.

Each file will be loaded into a partition.

My temp table shows correct row count from CSV file whereas ORC table missed some rows.

i checked the format of the missing rows and they are same as the other rows.

any idea why.?

Regards,

Sai

1 REPLY 1

Re: Hive ORC Table rows not matching with CSV file .

@Saikrishna Tarapareddy

I think issue with your csv data or delimiter which you are using while creating a table.