AnsweredAssumed Answered

Drill explorer mapr audit timestamps in non-chronological order when should be sorted

Question asked by reedv on Jan 30, 2018
Latest reply on Feb 20, 2018 by maprcommunity

Currently having problem where, when examining audit logs in the drill explorer, the timestamps of the logs have no discernible order (despite clicking the column header to sort in either descending or ascending order). Eg.

 

Notice that the times go from 1PM back to 9AM forward to 11AM. This does not makes sense to me.

 

 

Yet, I don't seem to have the same problem when querying directly in drill explorer with something like

SELECT `timestamp`, `uid`, `user` FROM `dfs`.`root`.`./some/folder/of/audit/logs/229278468` as t order by t.`timestamp` desc

So does clicking the column header not sort the column?

If anyone has seen anything like this before, any advice would be helpful. Thanks.

Outcomes