[ 
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)

Reply via email to