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