Hive
  1. Hive
  2. HIVE-675

Add Database/Schema support to Hive QL

    Details

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

      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

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development