Section 8:75.Inserting Data into order_items using stage table

In Hive, you can use a stage table to insert data into a target table. A stage table is a temporary table that you create to hold the data that you want to insert into the target table. You can then use the INSERT INTO statement to insert the data from the stage table into the target table.

 Here our target table is order_items and stage table is order_items_satge

1.Create stage table

2.Load the data to stage table 

3.Insert the data into stage table to target table

Share this post