Until now, we have learned how to insert data into partitions in a table one at a time. For that, it was important for us to know in which partition we need to insert data. Further, only one partition can be inserted using one INSERT statement. Now, we will learn how to insert data into multiple partitions through a single statement. The general syntax of inserting data into multiple partitions is as follows:
FROM tablename INSERT OVERWRITE TABLE tablename1 PARTITION(root_partition_name='value',child_partition_name) SELECT select_statment;
Where:
tablename: This is the name of the table from which the value is to be taken by the select statementtablename1: This is the name of the table in which the data will be insertedroot_partition_name: This is the static partition columnchild_partition_name: This is the dynamic partition column
This recipe requires having Hive installed as described in the Installing Hive recipe of Chapter 1, Developing...