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

Add Database/Schema support to Hive QL

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.6.0
    • Metastore, Query Processor
    • None
    • Reviewed
    • This ticket adds the ability to CREATE DATABASE, DROP DATABASE, and USE <database>. Please note that Hive does not yet support the ability to run a query that selects from tables in more than one database.

    Description

      Currently all Hive tables reside in single namespace (default). Hive should support multiple namespaces (databases or schemas) such that users can create tables in their specific namespaces. These name spaces can have different warehouse directories (with a default naming scheme) and possibly different properties.

      There is already some support for this in metastore but Hive query parser should have this feature as well.

      Attachments

        1. HIVE-675.10.patch.txt
          433 kB
          Carl Steinbach
        2. HIVE-675.11.patch.txt
          429 kB
          Carl Steinbach
        3. HIVE-675.12.patch.txt
          835 kB
          Carl Steinbach
        4. HIVE-675.13.patch.txt
          842 kB
          Carl Steinbach
        5. hive-675-2009-9-16.patch
          65 kB
          He Yongqiang
        6. hive-675-2009-9-19.patch
          66 kB
          He Yongqiang
        7. hive-675-2009-9-21.patch
          64 kB
          He Yongqiang
        8. hive-675-2009-9-23.patch
          66 kB
          He Yongqiang
        9. hive-675-2009-9-7.patch
          54 kB
          He Yongqiang
        10. hive-675-2009-9-8.patch
          63 kB
          He Yongqiang
        11. HIVE-675-2010-08-16.patch.txt
          425 kB
          Carl Steinbach
        12. HIVE-675-2010-7-16.patch.txt
          121 kB
          Carl Steinbach
        13. HIVE-675-2010-8-4.patch.txt
          369 kB
          Carl Steinbach
        14. HIVE-675-backport-v6.1.patch.txt
          1.10 MB
          Carl Steinbach
        15. HIVE-675-backport-v6.2.patch.txt
          1.11 MB
          Carl Steinbach

        Issue Links

        blocks

        New Feature - A new feature of the product, which has yet to be developed. HIVE-1010 Implement INFORMATION_SCHEMA in Hive

        • Major - Major loss of function.
        • Closed
        duplicates

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-191 Update methods in Hive class to specify database name

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

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-850 moving SessionState from ql to common

        • Major - Major loss of function.
        • Open

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-584 Clean up global and ThreadLocal variables in Hive

        • Major - Major loss of function.
        • Closed
        is depended upon by

        Bug - A problem which impairs or prevents the functions of the product. HIVE-1591 Lock the database also as part of locking a table/partition

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. HIVE-1591 Lock the database also as part of locking a table/partition

        • Major - Major loss of function.
        • Open
        is duplicated by

        New Feature - A new feature of the product, which has yet to be developed. HIVE-847 support show databases

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

        Bug - A problem which impairs or prevents the functions of the product. HIVE-1590 DDLTask.dropDatabase() needs to populate inputs/outputs

        • Major - Major loss of function.
        • Resolved

        New Feature - A new feature of the product, which has yet to be developed. HIVE-846 move hive tables from one database to another

        • Major - Major loss of function.
        • Resolved

        New Feature - A new feature of the product, which has yet to be developed. HIVE-847 support show databases

        • Major - Major loss of function.
        • Resolved

        New Feature - A new feature of the product, which has yet to be developed. HIVE-848 support mutilpe databse support in HWI

        • Major - Major loss of function.
        • Resolved

        New Feature - A new feature of the product, which has yet to be developed. HIVE-849 <database_name>.<table_name>.<column_name> not supported

        • Major - Major loss of function.
        • Resolved

        New Feature - A new feature of the product, which has yet to be developed. HIVE-1537 Allow users to specify LOCATION in CREATE DATABASE statement

        • Major - Major loss of function.
        • Closed

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-850 moving SessionState from ql to common

        • Major - Major loss of function.
        • Open

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-1960 Database feature should be documented

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

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-1517 ability to select across a database

        • Blocker - Blocks development and/or testing work, production could not run
        • Closed
        relates to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-1607 Reinstate and deprecate IMetaStoreClient methods removed in HIVE-675

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-6601 alter database commands should support schema synonym keyword

        • Major - Major loss of function.
        • Closed

        New Feature - A new feature of the product, which has yet to be developed. HIVE-1636 Implement "SHOW TABLES {FROM | IN} db_name"

        • Major - Major loss of function.
        • Closed

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

          People

            cwsteinbach Carl Steinbach Assign to me
            prasadc Prasad Chakka
            Votes:
            1 Vote for this issue
            Watchers:
            19 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment