Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive ORC or AVRO format with field delimiters

avatar
Expert Contributor

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")
1 ACCEPTED SOLUTION

avatar
Guru

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.

View solution in original post

1 REPLY 1

avatar
Guru

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.