[
https://issues.apache.org/jira/browse/SENTRY-1626?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15925200#comment-15925200
]
Lei (Eddy) Xu commented on SENTRY-1626:
---------------------------------------
[~kkalyan] Do you think whether it makes sense to update the sql scripts to
specify {{changeTime}} as a {{timestamp}} type, and set the value in SQL when
creating it?
> 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
> Priority: Minor
> 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)
