[SENTRY-1626] Tables contain createTime should either remove it or update the time using SQL

• Type: Bug
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Component/s: Hdfs Plugin
• Assignee: Lei (Eddy) Xu
• Reporter: Lei (Eddy) Xu
• Created: 13/Feb/17 21:03
• Updated: 10/Apr/17 18:00

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.

Issue Links

• links to: Review board