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

Add Database/Schema support to Hive QL



    • 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.


      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.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



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