You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vihang Karajgaonkar (JIRA)" <ji...@apache.org> on 2018/12/28 20:36:00 UTC

[jira] [Updated] (HIVE-21077) Database should have creation time

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