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.?
I think issue with your csv data or delimiter which you are using while creating a table.