Hive 'Load' command not considering Field Delimiter

[#1]

Hi

I am trying to create a hive table using Hive CLI on Hortonworks Sandbox as well as on C3 Cluster. In my 'CREATE TABLE' command, i specify the following:

FIELDS TERMINATED BY '\u0010' 

and then i load the table using the 'LOAD' command. This is giving a correct Hive Table in Sandbox but on C3 cluster, this appends all the fields in the first column and gives NULL values for the rest of the columns.

Please help me to resolve the issue.

Thanks

[#2 · Accepted solution]

Issue resolved. Look at this link.