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

Add Database/Schema support to Hive QL

    Details

    • 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:
      None
    • Hadoop Flags:
      Reviewed
    • 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.

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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: