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

Add Database/Schema support to Hive QL

    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-2009-9-7.patch
          54 kB
          He Yongqiang
        2. hive-675-2009-9-8.patch
          63 kB
          He Yongqiang
        3. hive-675-2009-9-16.patch
          65 kB
          He Yongqiang
        4. hive-675-2009-9-19.patch
          66 kB
          He Yongqiang
        5. hive-675-2009-9-21.patch
          64 kB
          He Yongqiang
        6. hive-675-2009-9-23.patch
          66 kB
          He Yongqiang
        7. HIVE-675-2010-7-16.patch.txt
          121 kB
          Carl Steinbach
        8. HIVE-675-2010-8-4.patch.txt
          369 kB
          Carl Steinbach
        9. HIVE-675-2010-08-16.patch.txt
          425 kB
          Carl Steinbach
        10. HIVE-675.10.patch.txt
          433 kB
          Carl Steinbach
        11. HIVE-675.11.patch.txt
          429 kB
          Carl Steinbach
        12. HIVE-675.12.patch.txt
          835 kB
          Carl Steinbach
        13. HIVE-675.13.patch.txt
          842 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

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: