[
https://issues.apache.org/jira/browse/HIVE-4086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13588655#comment-13588655
]
Todd Wilson commented on HIVE-4086:
-----------------------------------
Hello Jarcec:
Thank you for the reply. I appreciate this. I figured you might have
something like this, but I couldn't find it. It was my first time entering an
issue so I was assuming I'd do something wrong!
As far as the USE command goes, I'll give that a try. I actually didn't
realize this command was supported. That would help a lot in what I'm trying
to do. I'm switching back between a lot of data sources like Teradata,
ParAccel, Kognitio so sometimes my brain gets scrambled. :p
Thank you again.
Best Regards,
Todd Wilson
Senior Technical Consultant
Coffing Data Warehousing
(513) 292-3158
www.CoffingDW.com
********************************
The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of the
addressee. Unauthorized use, disclosure, distribution or copying is strictly
prohibited and may be unlawful. If you have received this communication in
error, please notify the sender immediately at gene...@coffingdw.com.
*********************************
> 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
