[
https://issues.apache.org/jira/browse/DRILL-6135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16353638#comment-16353638
]
Hari Sekhon edited comment on DRILL-6135 at 2/6/18 9:37 AM:
------------------------------------------------------------
[~julianhyde]
I think SHOW CREATE <name> is better as it stays in line with other SQL
systems. This should also be applied to both tables and views. Examples include
MySQL and Presto / AWS Athena:
[https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html]
[https://docs.aws.amazon.com/athena/latest/ug/show-create-table.html]
was (Author: harisekhon):
[~julianhyde]
I think SHOW CREATE <name> is better as it stays in line with other SQL
systems. This should also be applied to tables etc. Examples include MySQL and
Presto / AWS Athena:
[https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html]
[https://docs.aws.amazon.com/athena/latest/ug/show-create-table.html]
> 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)
