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

Cross Database Support for Indexes and Partitions (or all DDL statements)

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.9.0
    • Fix Version/s: None
    • Component/s: Database/Schema, ODBC, SQL
    • Labels:
      None
    • Environment:

      Writing a query tool in .NET connecting with ODBC to Hadoop on Linux.

      Description

      I'd like to see more cross-database support. I'm using a Cloudera implementation on Hive .9. Currently, you can create new databases, you can create tables and views in those databases, but you cannot create indexes or partitions on those tables. Likewise, commands like show partitions or show indexes will only work on table in the default database. This would probably also affect statements like Alter Table and Recover Partitions. Probably also something like Create Function, but if you want to keep all functions being created in the default database that would work. I would be more interested in full cross-database support for tables and views to start. Functions for example could all be created in default. Thank you.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                toadrw Todd Wilson
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: