drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hari Sekhon (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (DRILL-6135) New Feature: SHOW CREATE VIEW command
Date Tue, 06 Feb 2018 09:36:00 GMT

    [ 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:35 AM:
------------------------------------------------------------

[~julianhyde]

SHOW CREATE ... 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]

 


was (Author: harisekhon):
[~julianhyde]

SHOW CREATE ... is better as it stays in line with other SQL systems. This should also be
applied to tables etc.

> New Feature: SHOW CREATE 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)

Mime
View raw message