...
AUTHORIZATION
is supported from HIVE 0.14.0 via HIVE-5961.VECTORIZATION
is supported from Hive 2.3.0 via HIVE-11394.LOCKS
is supported from Hive 3.2.0 via HIVE-17683.
The use of EXTENDED
in the EXPLAIN
statement produces extra information about the operators in the plan. This is typically physical information like file names.
...
This is useful to understand what locks the system will acquire to run the specified query. Since Since Hive release 3.2.0 (HIVE-17683).
For example
Code Block |
---|
EXPLAIN LOCKS UPDATE target SET b = 1 WHERE p IN (SELECT t.q1 FROM source t WHERE t.a1=5) |
...
Adds detail to the EXPLAIN output showing why Map and Reduce work is not vectorized. Since Hive release 2.3.0 (HIVE-11394).
Syntax: EXPLAIN VECTORIZATION [ONLY] [SUMMARY|OPERATOR|EXPRESSION|DETAIL]
...