The Hadoop in Real World team takes us through an interesting insertion problem:
When we attempt to insert in to the employee_depts table with the below INSERT, the insert operation will fail with TOK_FUNCTION not supported in insert/values SemanticException.
The solution is straightforward but not something I would have figured out intuitively.