Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-6601

alter database commands should support schema synonym keyword

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.14.0
    • None
    • None

    Description

      It should be possible to use "alter schema" as an alternative to "alter database". But the syntax is not currently supported.

      alter schema db1 set owner user x;  
NoViableAltException(215@[])
FAILED: ParseException line 1:6 cannot recognize input near 'schema' 'db1' 'set' in alter statement

      Attachments

        1. HIVE-6601.1.patch.txt
          3 kB
          Navis Ryu

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-7047 Support schema keyword in alter database statements

          • Major - Major loss of function.
          • Resolved
          is related to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-675 Add Database/Schema support to Hive QL

          • Major - Major loss of function.
          • Closed
          relates to

          Sub-task - The sub-task of the issue HIVE-6440 sql std auth - add command to change owner of database

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              navis Navis Ryu
              thejas Thejas Nair
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: