CCA159 : Task Scenario-23

Problem Scenario 23 : Use tables created from previous exercise

Create  a static Partitioned tables, based on order_id and all the fields must be separated bt '~' : 

1. Add two static partitions 8999 and 9000.

2. Load all the orders which has order id <9000 in partition 8999.

3. Load all the orders which has order id > 9000 in partition 9000.