Parquet to ORC format in Hive

Question

I have data in hive managed table(xyz table) with parquet format. I want to convert this into ORC format.

Steps that i used.

• Created a sample table(tmp orc table) and saved it as ORC.
• Loaded the data from (xyz table) Parquet table into the new created table(tmp orc table) 

but it is failing.

Answer 1

Follow the below steps to load the data into an orc table from a parquet table in hive,

1) Create a table and load data in it,

I have created a table, stored it as a textfile and loaded the text file in it as the text file cannot be loaded directly in the parquet table.

​

2) Create a parquet table,

3) Insert the data in the parquet table from the text table,

4) Check if the data is inserted into the parquet table or not,

5) Create an orc table

6) Insert the data in the orc table from the parquet table

7) Check the contents of the orc table