check date and time of access to some kudu table

[#1]

hello cloudera community

Is it possible to know the date and time that a kudu table was accessed/read?

i know there is "transient_lastDdlTime" field in kudu table but that field is updated only when the table is updated.

[#2]

Hi @yagoaparecidoti @Cloudera any update on this request ?

[#3 · Accepted solution]

hi @Rajat_jangra ,

using the "audit" option in ranger, I was able to get the information I wanted.

[#4]

Hi @yagoaparecidoti thanks for the info, but can we get same kind of details in CDH cluster, is it possible using sentry or anything?

[#5]

hi @Rajat_jangra 

in CDH you will have to filter the Hive and Impala logs to know when the tables were accessed.

i recommend that you leave the logs open and then access a table using Impala and monitor it live in the logs, so you will know which filter to use.