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

Add Database/Schema support to Hive QL


    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.6.0
    • Component/s: Metastore, Query Processor
    • Labels:
    • Hadoop Flags:
    • Release Note:
      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.


      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.


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

          Issue Links



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


                • Created: