[jira] [Commented] (CALCITE-1168) Extend EXPLAIN statement

["Julian Hyde (JIRA)" <ji...@apache.org>]

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

Julian Hyde commented on CALCITE-1168:
--------------------------------------

I don't think we should use MySQL as a model. They are not very good at reading the SQL standard before they implement features.

And in fact recent versions of the standard have "DESCRIBE query". I don't want to clash with that.

I propose that we keep EXPLAIN as is, but add DESCRIBE SCHEMA name, DESCRIBE TABLE name, DESCRIBE query.

> Extend EXPLAIN statement
> ------------------------
>
>                 Key: CALCITE-1168
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1168
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>            Reporter: Arina Ielchiieva
>            Assignee: Julian Hyde
>
> Extend EXPLAIN statement so it can support the following:
> {noformat}
> [EXPLAIN | DESCRIBE] [SCHEMA | DATABASE] name;
> [EXPLAIN | DESCRIBE] table_name;
> {noformat}
> Example, [usage in MySql|http://dev.mysql.com/doc/refman/5.7/en/explain.html]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)