1-844-696-6465 (US)        +91 77600 44484        help@dezyre.com

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.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)