Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21077

Database and catalogs should have creation time

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.0, 3.2.0
    • Component/s: Standalone Metastore
    • Labels:
      None

      Description

      Currently, database do not have creation time like we have for tables and partitions.

      // namespace for tables
      struct Database {
        1: string name,
        2: string description,
        3: string locationUri,
        4: map<string, string> parameters, // properties associated with the database
        5: optional PrincipalPrivilegeSet privileges,
        6: optional string ownerName,
        7: optional PrincipalType ownerType,
        8: optional string catalogName
      }
      

      Currently, without creationTime there is no way to identify if the copy of Database which a client has is the same as the one on the server if the name is same. Without object ids creationTime value is the only way currently to identify uniquely a instance of metastore object. It would be good to have Database creation time as well.

      Same applies for catalogs as well.

        Attachments

        1. HIVE-21077.01.patch
          38 kB
          Vihang Karajgaonkar
        2. HIVE-21077.02.patch
          59 kB
          Vihang Karajgaonkar
        3. HIVE-21077.03.patch
          59 kB
          Vihang Karajgaonkar
        4. HIVE-21077.04.patch
          67 kB
          Vihang Karajgaonkar
        5. HIVE-21077.05.patch
          68 kB
          Vihang Karajgaonkar
        6. HIVE-21077.06.patch
          68 kB
          Vihang Karajgaonkar
        7. HIVE-21077.07.patch
          68 kB
          Vihang Karajgaonkar
        8. HIVE-21077.08.branch-3.patch
          75 kB
          Vihang Karajgaonkar
        9. HIVE-21077.09.patch
          74 kB
          Vihang Karajgaonkar
        10. HIVE-21077.10.patch
          74 kB
          Vihang Karajgaonkar
        11. HIVE-21077.addendum.patch
          3 kB
          Vihang Karajgaonkar

          Issue Links

            Activity

              People

              • Assignee:
                vihangk1 Vihang Karajgaonkar
                Reporter:
                vihangk1 Vihang Karajgaonkar
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: