...
When enabled, will log EXPLAIN EXTENDED output for the query at log4j INFO level and in HiveServer2 WebUI / Drilldown / Query Plan.
From Hive 3.1.0 onwards, this config configuration property only logs to the log4j INFO. To log the EXPLAIN EXTENDED output EXTENDED output in WebUI / Drilldown / Query Plan from Hive 3.1.0 onwards, use hive.server2.webui.explain.output.
...
hive.server2.webui.explain.output
- Default Value:
false
- Added in: Hive 3.1.0 with HIVE-18469
The The EXPLAIN EXTENDED output for the query will be shown in the WebUI / Drilldown / Query Plan tab when this configuration property is set to true.
Prior to Hive 3.1.0, you can use hive.log.explain.output instead of this configuration property.
Spark
Apache Spark was added in Hive 1.1.0 (HIVE-7292 and the merge-to-trunk JIRA's HIVE-9257, 9352, 9448). For information see the design document Hive on Spark and Hive on Spark: Getting Started.
...