https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Load-command-not-considering-Field-Delimiter/m-p/201227#M59572 <P>Hi</P><P>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:</P><PRE>FIELDS TERMINATED BY '\u0010' </PRE><P>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. </P><P>Please help me to resolve the issue.</P><P>Thanks</P> Tue, 18 Apr 2017 01:10:35 GMT rakarnani 2017-04-18T01:10:35Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Load-command-not-considering-Field-Delimiter/m-p/201227#M59572 <P>Hi</P><P>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:</P><PRE>FIELDS TERMINATED BY '\u0010' </PRE><P>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. </P><P>Please help me to resolve the issue.</P><P>Thanks</P> Tue, 18 Apr 2017 01:10:35 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Load-command-not-considering-Field-Delimiter/m-p/201227#M59572 rakarnani 2017-04-18T01:10:35Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Load-command-not-considering-Field-Delimiter/m-p/201228#M59573 <P> Issue resolved. Look at <A href="http://stackoverflow.com/questions/43449734/hive-load-command-not-considering-field-delimiter/43450152#43450152">this</A> link.</P> Tue, 18 Apr 2017 12:01:43 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Load-command-not-considering-Field-Delimiter/m-p/201228#M59573 rakarnani 2017-04-18T12:01:43Z