...
Code Block |
---|
EXPLAIN [EXTENDED|AST|DEPENDENCY|AUTHORIZATION|LOCKS|VECTORIZATION|ANALYZE] query
|
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.
...
See HIVE-11394 for more details and examples.
The ANALYZE Clause
Annotates the plan with actual row counts. Since in Hive 2.2.0 (HIVE-14362)
Format is: (estimated row count) / (actual row count)
Example:
For the below tablescan; the estimation was 500 rows; but actually the scan only yielded 13 rows.
Code Block |
---|
[...]
TableScan [TS_13] (rows=500/13 width=178)
Output:["key","value"]
[...] |
User-level Explain Output
...