[ https://issues.apache.org/jira/browse/HIVE-21077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vihang Karajgaonkar updated HIVE-21077: --------------------------------------- Description: Currently, database do not have creation time like we have for tables and partitions. {noformat} // 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 } {noformat} 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. was: Currently, database do not have creation time like we have for tables and partitions. {noformat} // 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 } {noformat} Currently, without creationTime there is no way to identify if the copy of Database which a client has is the same as the one no the server if the dbName is same. Without object ids creationTimeStamp is the only way currently to identify uniquely a instance of metastore object. It would be good to have Database creation time as well. > Database should have creation time > ---------------------------------- > > Key: HIVE-21077 > URL: https://issues.apache.org/jira/browse/HIVE-21077 > Project: Hive > Issue Type: Improvement > Components: Standalone Metastore > Reporter: Vihang Karajgaonkar > Assignee: Vihang Karajgaonkar > Priority: Major > > Currently, database do not have creation time like we have for tables and > partitions. > {noformat} > // 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 > } > {noformat} > 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)