Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Fixed
-
Impala 1.2.4
-
None
-
ghx-label-7
Description
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.