You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Harshit Gupta (Jira)" <ji...@apache.org> on 2021/03/07 03:46:00 UTC

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

    [ 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)