Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.7.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      We should be able to assign key-value pairs of properties to Hive databases.

      The proposed syntax is similar to the CREATE TABLE and CREATE INDEX commands:

      CREATE DATABASE <DB_NAME> WITH DBPROPERTIES ('key1' = 'value1', 'key2' = 'value2');
      

      The

      DESC DATABASE EXTENDED <DB_NAME>;
      

      should be able to display the properties. (requires HIVE-1821)

        Issue Links

          Activity

          Hide
          Ning Zhang added a comment -

          Attaching HIVE-1836.patch that addresses both HIVE-1821 (DESC DATABASE) and 1836 (CREATE DATABASE WITH DBPROPERTIES).

          Show
          Ning Zhang added a comment - Attaching HIVE-1836 .patch that addresses both HIVE-1821 (DESC DATABASE) and 1836 (CREATE DATABASE WITH DBPROPERTIES).
          Hide
          Namit Jain added a comment -

          If you are doing this, do you want to add a 'alter database' also ?

          Show
          Namit Jain added a comment - If you are doing this, do you want to add a 'alter database' also ?
          Hide
          Ning Zhang added a comment -

          Yes, will add 'alter database' also in a follow-up JIRA. A question is that if alter the current database, wether to change the HiveConf parameters accordingly. Since 'alter database' is not a blocking issue yet, I'm working on HIVE-1820 first and then come back to that.

          Show
          Ning Zhang added a comment - Yes, will add 'alter database' also in a follow-up JIRA. A question is that if alter the current database, wether to change the HiveConf parameters accordingly. Since 'alter database' is not a blocking issue yet, I'm working on HIVE-1820 first and then come back to that.
          Hide
          Namit Jain added a comment -

          OK, I will file a follow-up task for 'alter database'.

          I think, the simple semantics can be:
          dont change the existing databases - the parameters are fixed at the time you select the database.

          I remermber, Oracle aso used to have the same semantics for a lot of security related issues - it is much simpler

          Show
          Namit Jain added a comment - OK, I will file a follow-up task for 'alter database'. I think, the simple semantics can be: dont change the existing databases - the parameters are fixed at the time you select the database. I remermber, Oracle aso used to have the same semantics for a lot of security related issues - it is much simpler
          Hide
          Namit Jain added a comment -

          +1

          Show
          Namit Jain added a comment - +1
          Hide
          Namit Jain added a comment -

          Committed. Thanks Ning

          Show
          Namit Jain added a comment - Committed. Thanks Ning

            People

            • Assignee:
              Ning Zhang
              Reporter:
              Ning Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development