[ 
https://issues.apache.org/jira/browse/SENTRY-1626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Hao Hao updated SENTRY-1626:
----------------------------
    Description: 
Most of the table in Sentry contains createTime, e.g {{MSentryRole}}, 
{{MSentryGroup}}, {{MSentryPermChange}}, {{MSentryPrivilege}}, 
{{MAuthzPathsMapping}} and {{MSentryPathChange}}. Even though it is not used, 
it may be error-prone for future.

The time between leader and standby servers might be different, so that after a 
failover, the newly elected leader might write changes with older 
{{createdTime}}.

We can either remove this field, or update the time based in the database.



  was:
Most of the table in Sentry contains createTime, e.g {{MSentryRole}}, 
{{MSentryPermChange}} and {{MSentryPathChange}}. Even though it is not used, it 
may be error-prone for future.

The time between leader and standby servers might be different, so that after a 
failover, the newly elected leader might write changes with older 
{{createdTime}}.

We can either remove this field, or update the time based in the database.




> Tables contain createTime should either remove it or update the time using SQL
> ------------------------------------------------------------------------------
>
>                 Key: SENTRY-1626
>                 URL: https://issues.apache.org/jira/browse/SENTRY-1626
>             Project: Sentry
>          Issue Type: Sub-task
>          Components: Hdfs Plugin
>    Affects Versions: sentry-ha-redesign
>            Reporter: Lei (Eddy) Xu
>            Assignee: Lei (Eddy) Xu
>             Fix For: sentry-ha-redesign
>
>
> Most of the table in Sentry contains createTime, e.g {{MSentryRole}}, 
> {{MSentryGroup}}, {{MSentryPermChange}}, {{MSentryPrivilege}}, 
> {{MAuthzPathsMapping}} and {{MSentryPathChange}}. Even though it is not used, 
> it may be error-prone for future.
> The time between leader and standby servers might be different, so that after 
> a failover, the newly elected leader might write changes with older 
> {{createdTime}}.
> We can either remove this field, or update the time based in the database.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to