What Does The Following Query Do? Insert Overwrite Table Employees Pa

1.	What Does The Following Query Do? Insert Overwrite Table Employees Partition (country, State) Select ..., Se.cnty, Se.st From Staged_employees Se;
Answer» It creates partition on table employees with partition VALUES coming from the COLUMNS in the SELECT CLAUSE. It is called Dynamic partition insert. It creates partition on table employees with partition values coming from the columns in the select clause. It is called Dynamic partition insert.

What Does The Following Query Do? Insert Overwrite Table Employees Partition (country, State) Select ..., Se.cnty, Se.st From Staged_employees Se;

Answer»

It creates partition on table employees with partition VALUES coming from the COLUMNS in the SELECT CLAUSE. It is called Dynamic partition insert.

It creates partition on table employees with partition values coming from the columns in the select clause. It is called Dynamic partition insert.