[
https://issues.apache.org/jira/browse/HIVE-24574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Mollitor updated HIVE-24574:
----------------------------------
Description:
Add a new statement to Hive called {{DIAGNOSE}}
{code:sql}
DIAGNOSE [WITH (PARQUET|ORC|JSON|AVRO) RESULTS] ...
{code}
Returns a single binary (BLOB) column which contains a TAR-GZ file comprised of
several other files:
* A JSON file containing HS2 version information, HS2 host name, date or query
submission, query id(s) etc.
* The query itself (file name is MD5 of the query)
* EXPLAIN plan (file name is MD5 of the explain plan)
* SHOW CREATE for each table in the query (<table_name.sql>)
* The configuration of the session (set)
* The Hive logs generated by the query
* The processing engine logs generated by the query
* Any counters associated with the processing engine
* Optionally, the results of the query in a single file (file name is MD5 of
the results)
was:
Add a new statement to Hive called {{DIAGNOSE}}
{code:sql}
DIAGNOSE [WITH (PARQUET|ORC|JSON|AVRO) RESULTS] ...
{code}
Returns a single binary (BLOB) column which contains a TAR-GZ file comprised of
several other files:
* A JSON file containing HS2 version information, HS2 host name, date or query
submission, etc.
* The query itself (file name is MD5 of the query)
* EXPLAIN plan (file name is MD5 of the explain plan)
* SHOW CREATE for each table in the query (<table_name.sql>)
* The configuration of the session (set)
* The Hive logs generated by the query
* The processing engine logs generated by the query
* Any counters associated with the processing engine
* Optionally, the results of the query in a single file (file name is MD5 of
the results)
> Add DIAGNOSE Statement
> ----------------------
>
> Key: HIVE-24574
> URL: https://issues.apache.org/jira/browse/HIVE-24574
> Project: Hive
> Issue Type: Improvement
> Reporter: David Mollitor
> Priority: Major
>
> Add a new statement to Hive called {{DIAGNOSE}}
> {code:sql}
> DIAGNOSE [WITH (PARQUET|ORC|JSON|AVRO) RESULTS] ...
> {code}
> Returns a single binary (BLOB) column which contains a TAR-GZ file comprised
> of several other files:
> * A JSON file containing HS2 version information, HS2 host name, date or
> query submission, query id(s) etc.
> * The query itself (file name is MD5 of the query)
> * EXPLAIN plan (file name is MD5 of the explain plan)
> * SHOW CREATE for each table in the query (<table_name.sql>)
> * The configuration of the session (set)
> * The Hive logs generated by the query
> * The processing engine logs generated by the query
> * Any counters associated with the processing engine
> * Optionally, the results of the query in a single file (file name is MD5 of
> the results)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)