VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Impala 1.2.4
    • Impala 2.13.0, Impala 3.1.0
    • Docs
    • 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.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            arodoni Alexandra Rodoni
            arodoni Alexandra Rodoni
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment