Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-462

ALTER DATABASE support to rename or move database

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Reopened
    • Minor
    • Resolution: Unresolved
    • Impala 1.1, Impala 2.3.0
    • Product Backlog
    • Catalog

    Description

      I suggest adding an ALTER DATABASE statement, for completeness and future expansion.
      Currently, Hive has ALTER DATABASE that AFAICT only allows a SET clause to change properties.

      One logical syntax / use case for an Impala ALTER DATABASE would be:

      ALTER DATABASE old_name RENAME TO new_name;

      (OK to disallow for the DEFAULT database or the currently USEd database.)

      Attachments

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. IMPALA-10172 Support Hive metastore managed locations for databases

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

          New Feature - A new feature of the product, which has yet to be developed. HIVE-4847 add rename database functionality

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-8472 Add ALTER DATABASE SET LOCATION

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              jrussell John Russell
              Votes:
              5 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: