Versions Compared

Old Version 23

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 24

changes.mady.by.user Andrew Sears

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Surface vectorization functionality in wiki from HIVE-11394

...

is also supported which will produce JSON encoded output.


The VECTORIZATION Clause

Adds detail to the EXPLAIN output showing why Map and Reduce work is not vectorized.

Syntax: EXPLAIN VECTORIZATION [ONLY] [SUMMARY|OPERATOR|EXPRESSION|DETAIL]

  • ONLY option suppresses most non-vectorization elements.
  • SUMMARY (default) shows vectorization information for the PLAN (is vectorization enabled) and a summary of Map and Reduce work.
  • OPERATOR shows vectorization information for operators. E.g. Filter Vectorization. Includes all information of SUMMARY.
  • EXPRESSION shows vectorization information for expressions. E.g. predicateExpression. Includes all information of SUMMARY and OPERATOR.
  • DETAIL shows detail-level vectorization information.  It includes all information of SUMMARY, OPERATOR, and EXPRESSION.

The optional clause defaults are not ONLY and SUMMARY.

See HIVE-11394 for more details and examples.

User-level Explain Output

...