1.

What does the following query do?INSERT OVERWRITE TABLE employeesPARTITION (country, state)SELECT ..., se.cnty, se.stFROM 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.



Discussion

No Comment Found