Hive
  1. Hive
  2. HIVE-6601

alter database commands should support schema synonym keyword

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.14.0
    • Component/s: None
    • Labels:
      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
      

        Issue Links

          Activity

          Hide
          Thejas M Nair added a comment -

          This is the case with the other alter database command as well - ALTER DATABASE database_name SET DBPROPERTIES

          Show
          Thejas M Nair added a comment - This is the case with the other alter database command as well - ALTER DATABASE database_name SET DBPROPERTIES
          Hide
          Hive QA added a comment -

          Overall: -1 at least one tests failed

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12658100/HIVE-6601.1.patch.txt

          ERROR: -1 due to 4 failed/errored test(s), 5770 tests executed
          Failed tests:

          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_optimization
          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_ql_rewrite_gbtoidx
          org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes
          org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection
          

          Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/76/testReport
          Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/76/console
          Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-76/

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          Tests exited with: TestsFailedException: 4 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12658100

          Show
          Hive QA added a comment - Overall : -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12658100/HIVE-6601.1.patch.txt ERROR: -1 due to 4 failed/errored test(s), 5770 tests executed Failed tests: org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynpart_sort_optimization org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_ql_rewrite_gbtoidx org.apache.hive.hcatalog.pig.TestHCatLoader.testReadDataPrimitiveTypes org.apache.hive.jdbc.miniHS2.TestHiveServer2.testConnection Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/76/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/76/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-76/ Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 4 tests failed This message is automatically generated. ATTACHMENT ID: 12658100
          Hide
          Thejas M Nair added a comment -

          +1

          Show
          Thejas M Nair added a comment - +1
          Hide
          Navis added a comment -

          Committed to trunk. Thanks for the review, Thejas.

          Show
          Navis added a comment - Committed to trunk. Thanks for the review, Thejas.
          Hide
          Lefty Leverenz added a comment -

          Documentation goes here:

          similar to create and drop database here (although it would be better to use new lines of syntax to show the version information, instead of "|" syntax):

          Show
          Lefty Leverenz added a comment - Documentation goes here: DDL – Alter Database similar to create and drop database here (although it would be better to use new lines of syntax to show the version information, instead of "|" syntax): DDL – Create/Drop/Alter Database
          Hide
          Lefty Leverenz added a comment -

          Documented by Navis and revised by the nitpicker (me). Please review:

          Show
          Lefty Leverenz added a comment - Documented by Navis and revised by the nitpicker (me). Please review: just the diffs Overview Alter Database Show Databases Show Locks Describe Database
          Hide
          Thejas M Nair added a comment -

          This has been fixed in 0.14 release. Please open new jira if you see any issues.

          Show
          Thejas M Nair added a comment - This has been fixed in 0.14 release. Please open new jira if you see any issues.

            People

            • Assignee:
              Navis
              Reporter:
              Thejas M Nair
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development