Page History

...

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.

[...]
              TableScan [TS_13] (rows=500/13 width=178)
                Output:["key","value"]
[...]

User-level Explain Output

...