Skip to main content
yagoaparecidoti
yagoaparecidoti
Gold ⭐️
May 30, 2023
Solved

check date and time of access to some kudu table

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.

yagoaparecidoti
yagoaparecidotiAnswer
Gold ⭐️
June 17, 2025

hi @Rajat_jangra ,

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

View in thread

4 replies

Rajat_jangra
Rajat_jangra
Silver ⭐️⭐️
June 17, 2025

Hi @yagoaparecidoti @Cloudera any update on this request ?

Translate
yagoaparecidoti
yagoaparecidotiAuthorAnswer
Gold ⭐️
June 17, 2025

hi @Rajat_jangra ,

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

Translate
    Rajat_jangra
    Rajat_jangra
    Silver ⭐️⭐️
    June 18, 2025

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

    Translate
    yagoaparecidoti
    yagoaparecidotiAuthor
    Gold ⭐️
    July 2, 2025

    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.

    Translate
    Terms & ConditionsAccessibility statement