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