I have data in a flat file that my hive table is reading from. It reads rest of the data just fine. However, I have a column with values like
which is typically an id and suggested datatype of hue while creating the table is int. I tried changing that to bigint, double and varchar but yet it shows NULL for all the values in the column.
However if I change it to a string, it shows this with in the quotes i.e
"408574322".How do I fix this?Why is it not able to read this sort of id's anywhere in any of the tables?
Int does allow values between
INT (4-byte signed integer, from
2,147,483,647). Refer to below link:
I don't think it is related to data type precision issue. Share the logs under /var/log/hue for analysis.
Have you already tried doing a create table as select @Simran Kaur, any luck with that ? Also, can you try this and share the output (make sure you have enough screen scroll buffer)
hive --hiveconf hive.root.logger=DEBUG,console