Hive ORC or AVRO format with field delimiters

[#1]

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?

For example,

CREATE TABLE if not exists T (
C1    STRING ,
C2    STRING )
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\001' 
STORED AS ORC tblproperties ("orc.compress"="SNAPPY")

[#2 · Accepted solution]

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.