[jira] [Comment Edited] (HIVE-24596) Explain ddl for debugging

[Harshit Gupta (Jira)]

[ 
https://issues.apache.org/jira/browse/HIVE-24596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17293868#comment-17293868
 ] 

Harshit Gupta edited comment on HIVE-24596 at 3/7/21, 3:45 AM:
---

Yeah Sure!!

Let's assume the following [^table_definitions] and the following [^query]. The 
explain ddl output for the query will look like this:[^output]

 

 


was (Author: harshit.gupta):
Yeah Sure!!

Let's assume the following [^table_definitions] and the following [^query]. The 
explain ddl output for the query will look like [^explain_ddl_output]

 

 

> Explain ddl for debugging
> -
>
> Key: HIVE-24596
> URL: https://issues.apache.org/jira/browse/HIVE-24596
> Project: Hive
>  Issue Type: Improvement
>Reporter: Rajesh Balamohan
>Assignee: Harshit Gupta
>Priority: Major
>  Labels: pull-request-available
> Attachments: output, query, table_definitions
>
>  Time Spent: 20m
>  Remaining Estimate: 0h
>
> For debugging query issues, basic details like table schema, statistics, 
> partition details, query plans are needed.
> It would be good to have "explain ddl" support, which can generate these 
> details. This can help in recreating the schema and planner issues without 
> sample data.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Comment Edited] (HIVE-24596) Explain ddl for debugging

[Rajesh Balamohan (Jira)]

[ 
https://issues.apache.org/jira/browse/HIVE-24596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17260223#comment-17260223
 ] 

Rajesh Balamohan edited comment on HIVE-24596 at 1/7/21, 4:34 AM:
--

HIVE-24596 is on similar lines, but with much broader scope. This can be moved 
as a subtask or linked off to it later.


was (Author: rajesh.balamohan):
HIVE-24596 is on similar lines, but with much broader scope. This can be moved 
as a related or a subtask later.

> Explain ddl for debugging
> -
>
> Key: HIVE-24596
> URL: https://issues.apache.org/jira/browse/HIVE-24596
> Project: Hive
>  Issue Type: Improvement
>Reporter: Rajesh Balamohan
>Assignee: Harshit Gupta
>Priority: Major
>
> For debugging query issues, basic details like table schema, statistics, 
> partition details, query plans are needed.
> It would be good to have "explain ddl" support, which can generate these 
> details. This can help in recreating the schema and planner issues without 
> sample data.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)