hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Jarcec Cecho (JIRA)" <>
Subject [jira] [Commented] (HIVE-4086) Cross Database Support for Indexes and Partitions (or all DDL statements)
Date Wed, 27 Feb 2013 18:51:14 GMT


Jarek Jarcec Cecho commented on HIVE-4086:

Hi Todd,
thank you very much for reporting this issue. We already have JIRA HIVE-4064 to track this
requirement so I'm closing this one as a duplicate to keep all the information in one place.

To immediately unblock you, did you consider using SQL query {{USE <dbname>}} to change
working database from {{default}} to {{<dbname>}}?

> Cross Database Support for Indexes and Partitions (or all DDL statements)
> -------------------------------------------------------------------------
>                 Key: HIVE-4086
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: Database/Schema, ODBC, SQL
>    Affects Versions: 0.9.0
>         Environment: Writing a query tool in .NET connecting with ODBC to Hadoop on Linux.
>            Reporter: Todd Wilson
> 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

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message