https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-or-AVRO-format-with-field-delimiters/m-p/146617#M28239 <P>What does it mean for a hive table with ORC or Avro format to have the Field delimiter specified? Does hive ignore even if its specified?</P><P>For example,</P><PRE><CODE>CREATE TABLE if not exists T ( C1 STRING , C2 STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS ORC tblproperties ("orc.compress"="SNAPPY")</CODE></PRE> Fri, 13 May 2016 20:53:14 GMT learninghuman 2016-05-13T20:53:14Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-or-AVRO-format-with-field-delimiters/m-p/146617#M28239 <P>What does it mean for a hive table with ORC or Avro format to have the Field delimiter specified? Does hive ignore even if its specified?</P><P>For example,</P><PRE><CODE>CREATE TABLE if not exists T ( C1 STRING , C2 STRING ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS ORC tblproperties ("orc.compress"="SNAPPY")</CODE></PRE> Fri, 13 May 2016 20:53:14 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-or-AVRO-format-with-field-delimiters/m-p/146617#M28239 learninghuman 2016-05-13T20:53:14Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-or-AVRO-format-with-field-delimiters/m-p/146618#M28240 <P>Yes. Once you specific STORED AS ORC, OrcSerde is what is used which ignores those. Your SerDe can decide which of them in create table script can be used.</P> Sat, 14 May 2016 02:21:18 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-or-AVRO-format-with-field-delimiters/m-p/146618#M28240 ravi1 2016-05-14T02:21:18Z