Support Questions

Find answers, ask questions, and share your expertise

Can Hive Check data type correctness when reading a csv file?

New Contributor

So I have installed hive on my server. Now I need to load tons of data, into hive tables. Is there any configuration to check when the data type inserted from the CSV is not the same as its supposed column? As far as I know, if the CSV contains a string in the column that is supposed to be an integer (or another data type) the hive table will consider it as an empty cell.

1 REPLY 1

Expert Contributor

Hi,

 

I do not think we have such configuration to validate the data, We need to ensure that data matches with the table that we have created.

 

Regards,

Chethan YM