[jira] [Commented] (DRILL-6135) New Feature: SHOW CREATE TABLE / VIEW command

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

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

Julian Hyde commented on DRILL-6135:
------------------------------------

After some research, I agree that {{SHOW CREATE}} seems to be the standard. As you say, MySQL and Presto (and its derivative, Athena) support it. Also Hive supports it; see HIVE-967. Oracle, PostgreSQL, DB2, SQL Server do not have an equivalent (other than using stored procedures).

There is a minor concern for how we would generate DDL for sub-objects such as columns and foreign keys, which do not have their own CREATE statement but nevertheless could have their own DDL fragment.

> New Feature: SHOW CREATE TABLE / VIEW command
> ---------------------------------------------
>
>                 Key: DRILL-6135
>                 URL: https://issues.apache.org/jira/browse/DRILL-6135
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Metadata, Storage - Information Schema
>    Affects Versions: 1.10.0
>         Environment: MapR 5.2 + Kerberos
>            Reporter: Hari Sekhon
>            Priority: Major
>
> Feature Request to implement
> {code:java}
> SHOW CREATE VIEW <name>;{code}
> A colleague and I just had to cat the view file which is non-pretty json and hard to read a large view creation statement that could have been presented in drill shell and formatted.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)