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