[jira] [Resolved] (IMPALA-6676) Impala Doc: SHOW CREATE VIEW

["Alex Rodoni (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-6676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alex Rodoni resolved IMPALA-6676.
---------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.1.0
                   Impala 2.13.0

> Impala Doc: SHOW CREATE VIEW
> ----------------------------
>
>                 Key: IMPALA-6676
>                 URL: https://issues.apache.org/jira/browse/IMPALA-6676
>             Project: IMPALA
>          Issue Type: Sub-task
>          Components: Docs
>    Affects Versions: Impala 1.2.4
>            Reporter: Alex Rodoni
>            Assignee: Alex Rodoni
>            Priority: Major
>             Fix For: Impala 2.13.0, Impala 3.1.0
>
>
> SHOW CREATE TABLE now supports views. It returns a CREATE VIEW statement with column names and the original sql statement.
> Authorization allows SHOW CREATE TABLE to be run on view if the user has VIEW_METADATA privilege on the view and SELECT privilege on all
> underlying views and table.
> E.g. "SHOW CREATE TABLE some_view" returns output of form:
> CREATE VIEW a_database.some_view (id, bool_col, tinyint_col) AS
> SELECT id, bool_col, tinyint_col FROM functional.alltypes
> SHOW CREATE VIEW is available as an alias for SHOW CREATE TABLE.



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