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,
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MTIwOTczNSwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.PXfy15V2r6uTrn3xUEA_FjYIWwSxpYtJ3nv1tGl88SI)
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,
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MTIwOTkxOCwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.ZVugZT1yh3TNROHr8QKdlME49cvXtyEL9WvKsERDf1s)
3) Insert the data in the parquet table from the text table,
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MTIwOTc5OCwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.qd8C-B2jcmu1cqiFuNC6jeHh_BIz8BiXFljynv118A0)
4) Check if the data is inserted into the parquet table or not,
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MTIwOTgxNSwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.qJcge0sZiGZGUGsMw4uaP9Hpr29wH1zaLkzJ8faTygs)
5) Create an orc table
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MTIwOTgyNCwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.xVVVa_spDBVCvA302oTfflVxrRcLEJMwwqX-TDj-I0k)
6) Insert the data in the orc table from the parquet table
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MTIwOTgzMiwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.1Lb6oARy3QGkozUE-e0LFUmldb0C8dXSOpspezr3lV4)
7) Check the contents of the orc table
![image](https://attachment.freshdesk.com/inline/attachment?token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDA2MTIwOTg1MSwiZG9tYWluIjoiZWR1cmVrYS5mcmVzaGRlc2suY29tIiwiYWNjb3VudF9pZCI6NDE0NTN9.cgBBAnEpzeWbbjzQfD5-oirqOdaCOY-UxMo_wx21KSI)