1. Hive
  2. HIVE-675

Add Database/Schema support to Hive QL


    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major 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.13.patch.txt
        842 kB
        Carl Steinbach
      4. HIVE-675.12.patch.txt
        835 kB
        Carl Steinbach
      5. HIVE-675.11.patch.txt
        429 kB
        Carl Steinbach
      6. HIVE-675.10.patch.txt
        433 kB
        Carl Steinbach
      7. HIVE-675-2010-08-16.patch.txt
        425 kB
        Carl Steinbach
      8. HIVE-675-2010-8-4.patch.txt
        369 kB
        Carl Steinbach
      9. HIVE-675-2010-7-16.patch.txt
        121 kB
        Carl Steinbach
      10. hive-675-2009-9-23.patch
        66 kB
        He Yongqiang
      11. hive-675-2009-9-21.patch
        64 kB
        He Yongqiang
      12. hive-675-2009-9-19.patch
        66 kB
        He Yongqiang
      13. hive-675-2009-9-16.patch
        65 kB
        He Yongqiang
      14. hive-675-2009-9-8.patch
        63 kB
        He Yongqiang
      15. hive-675-2009-9-7.patch
        54 kB
        He Yongqiang

        Issue Links


          No work has yet been logged on this issue.


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


              • Created: