Parquet to ORC format in Spark

Question

I am currently having data on my hadoop Consumption table(xyz table) which is stored in Parquet format. I have a requirement to convert the data from this (xyz table) to ORC format using Hive.

I did create a temp table with ORC compression and tried to load the data from the xyz table to the new temp table. But I am unable to see the data.

I don't need the solution, because I want to try it by myself. Can you just mention the steps?

Answer 1

I appreciate that you want to try it by yourself. Here are the steps:

Step 1) First you need to create a table from Parquet table with "Stored As Text" 

Step 2) Secondly you can create A table from previous output as "Stored As ORC" 

Step 3) After that you can drop intermediate table.