I have staging area and data loaded in staging is in avro format . can I create ORC file from avro file format directly without creating avro table in hive ? as data in already in the binary format in avro , is it possible to directly create ORC table rather than first creating DDL in hive in avro format and later insert data in ORC table from avro ?
2. Through Hive tables - Yes, we can accomplish this by creating a new table with ORC storage format and inserting data from the table which has the data in Avro format. [table2 in the below example stores the data in ORC format and table1 in Avro]
CREATE TABLE test2
STORED AS ORC;
INSERT INTO test2
select * from test1;