[ https://issues.apache.org/jira/browse/HIVE-9018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14239332#comment-14239332 ]
Dapeng Sun commented on HIVE-9018: ---------------------------------- Good suggestion! Do you think it is possible to add a configuration {{dataformat}}, pass the argument {{dataformat}} to {{writeHiveRoleGrantInfo()}} and print the data format like this: {code:java|borderStyle=solid} SimpleDateFormat simpleDateFormat = new SimpleDateFormat("dd/MM/yyyy HH:mm:ss"); Date grantTime = testMode ? new Date(-1) :new Date(roleGrant.getGrantTime() * 1000L); appendNonNull(builder, simpleDateFormat.format(grantTime)); {code} > SHOW GRANT ROLE in Hive should return "grant_time" in human readable format > --------------------------------------------------------------------------- > > Key: HIVE-9018 > URL: https://issues.apache.org/jira/browse/HIVE-9018 > Project: Hive > Issue Type: Improvement > Reporter: Dapeng Sun > Priority: Minor > Attachments: HIVE-9018.003.patch, HIVE-9018.004.patch, > HIVE-9018.005.patch, HIVE-9018.006.patch, HIVE-9018.007.patch, > HIVE-9018.007.patch, HIVE-9018.008.patch, HIVE-9018.008.patch > > > Currently, "SHOW GRANT ROLE" will return the 'grant_time' in microseconds > since epoch. It would be nice if this were in human readable format. > Current output: 1411801585902000 > Desired output: Sat, Sep 27 2014 00:06:25.902 -- This message was sent by Atlassian JIRA (v6.3.4#6332)