We can see some steps to do that:
- Create a non-partitioned table X and load the data
- Now create a partitioned table Y and specify the partition column (say state)
- Load data from X to Y like below
You can use this command to create that:
hive> INSERT INTO TABLE Y PARTITION(state) SELECT * from X;
Here you should ensure that the partition column is the last column of the non-partitioned table.