InterviewSolution
Saved Bookmarks
| 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. |
|