[HIVE-21077] Database and catalogs should have creation time

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.2.0, 4.0.0-alpha-1
• Component/s: Standalone Metastore
• Assignee: Vihang Karajgaonkar
• Reporter: Vihang Karajgaonkar
• Created: 28/Dec/18 20:34
• Updated: 17/Nov/22 08:54
• Resolved: 22/Jan/19 18:37

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.

Issue Links

• is related to: HIVE-24453 Direct SQL error when parsing create_time value for database
• links to: rb link