Regarding saving data in Hive table

For example: Michigan, USA.
I am trying to save data in hive table with delimited fields terminated by ','. Instead of just Michigan and USA, why am I getting numbers in front of Michigan.

1 Answer(s)


Hi Shilpa,
Open the tweet in text-editor and compare with Hive delimiter used in table creation command.
Tip: Hive doesn't avoid any character while convert the file into Table only delimiters are used to partition the column.
For example- if you have input as - <"12345">,<"67890"> and delimiter is ','
The value inside the column will be <"12345"> <"67890">
It will consider every symbol.

Hope this helps.