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.

        Issue Links

          Activity

          Hide
          jarcec Jarek Jarcec Cecho added a comment -

          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>?

          Jarcec

          Show
          jarcec Jarek Jarcec Cecho added a comment - 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> ? Jarcec
          Hide
          toadrw Todd Wilson added a comment -

          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.

          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 general@coffingdw.com.
          *********************************

          Show
          toadrw Todd Wilson added a comment - 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. 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 general@coffingdw.com. *********************************
          Hide
          toadrw Todd Wilson added a comment -

          Hello Jarcec:

          Your suggestion for the USE command works when querying hive directly, but I'm using a couple of ODBC drivers (MapR and HortonWorks) and it looks like this command doesn't work (which made me think this command wasn't working/supported on Hive :/). Anyways, this is an ODBC issue I think. Thanks again for your help.

          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 general@coffingdw.com.
          *********************************

          Show
          toadrw Todd Wilson added a comment - Hello Jarcec: Your suggestion for the USE command works when querying hive directly, but I'm using a couple of ODBC drivers (MapR and HortonWorks) and it looks like this command doesn't work (which made me think this command wasn't working/supported on Hive :/). Anyways, this is an ODBC issue I think. Thanks again for your help. 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 general@coffingdw.com. *********************************
          Hide
          jarcec Jarek Jarcec Cecho added a comment -

          The USE db definitely works in hive shell and JDBC interface. I can't speak for the ODBC drivers unfortunately.

          Show
          jarcec Jarek Jarcec Cecho added a comment - The USE db definitely works in hive shell and JDBC interface. I can't speak for the ODBC drivers unfortunately.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development