question Re: check date and time of access to some kudu table in Support Questions

check date and time of access to some kudu table

yagoaparecidoti — Tue, 30 May 2023 20:49:12 GMT

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.

Re: check date and time of access to some kudu table

Rajat_jangra — Tue, 17 Jun 2025 09:56:25 GMT

Hi @yagoaparecidoti @Cloudera any update on this request ?

Re: check date and time of access to some kudu table

yagoaparecidoti — Tue, 17 Jun 2025 16:42:30 GMT

hi @Rajat_jangra ,

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

Re: check date and time of access to some kudu table

Rajat_jangra — Wed, 18 Jun 2025 09:51:55 GMT

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

Re: check date and time of access to some kudu table

yagoaparecidoti — Wed, 02 Jul 2025 20:24:03 GMT

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.