[
https://issues.apache.org/jira/browse/HIVE-4086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13588849#comment-13588849
]
Jarek Jarcec Cecho commented on HIVE-4086:
------------------------------------------
The {{USE db}} definitely works in hive shell and JDBC interface. I can't speak
for the ODBC drivers unfortunately.
> Cross Database Support for Indexes and Partitions (or all DDL statements)
> -------------------------------------------------------------------------
>
> Key: HIVE-4086
> URL: https://issues.apache.org/jira/browse/HIVE-4086
> 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 you.
--
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: http://www.atlassian.com/software/jira
