https://community.cloudera.com/t5/Support-Questions/Storing-Multiline-character-fields-in-hive-table/m-p/114753#M77547 <P>Hi,</P><P>I am trying to store multiline character fields in hive table. I tried using csv serde but the data is been shows as multiple records.</P><P><STRONG>Table description</STRONG></P><P></P><P><STRONG>CREATE EXTERNAL TABLE </STRONG>`serde_test1`(</P><P> </P><P> `num` <STRONG>string COMMENT </STRONG>'from deserializer', </P><P> </P><P> `name` <STRONG>string COMMENT </STRONG>'from deserializer')</P><P><STRONG> </STRONG></P><P><STRONG>ROW FORMAT SERDE </STRONG></P><P> </P><P>'com.bizo.hive.serde.csv.CSVSerde'</P><P><STRONG></STRONG> </P><P><STRONG>WITH SERDEPROPERTIES </STRONG>( </P><P> </P><P>'quoteChar'='\"', </P><P> </P><P>'separatorChar'=',') </P><P><STRONG> </STRONG></P><P><STRONG>STORED AS INPUTFORMAT </STRONG></P><P> </P><P>'org.apache.hadoop.mapred.TextInputFormat'</P><P><STRONG> </STRONG></P><P><STRONG>OUTPUTFORMAT </STRONG></P><P> </P><P>'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'</P><P><STRONG></STRONG> </P><P><STRONG>LOCATION </STRONG>'HDFS location';</P><P><STRONG>Data that is stored in hive:</STRONG></P><P>"300","test newline add testings"</P><P>If I select from hive table it shows as NULLs.</P><P></P><P>serde_test1.num serde_test1.name 300 (null) (null) (null)</P><P>Anybody has any idea on how to store multi line fields in hive table?</P> Mon, 25 Apr 2016 22:35:23 GMT adadi 2016-04-25T22:35:23Z