You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by elango vaidyanathan <el...@gmail.com> on 2020/03/16 16:44:58 UTC

Getting hive tables that are updated in last one week

Hi all,

I want to get the list of hive tables or dbs that are updated in last week?
We use HDP 3.1 and postgres as hive metastore. Also using atlas for all
hive tables which are tagged.

Please let me know.

Thanks,
Elango

Re: Getting hive tables that are updated in last one week

Posted by elango vaidyanathan <el...@gmail.com>.
The following property helped me to get what I needed.

show TBLPROPERTIES schemaname.tablename ('transient_lastDdlTime')

Thanks,
Elango

On Mon, Mar 16, 2020, 10:14 PM elango vaidyanathan <el...@gmail.com>
wrote:

>
>
> Hi all,
>
> I want to get the list of hive tables or dbs that are updated in last
> week? We use HDP 3.1 and postgres as hive metastore. Also using atlas for
> all hive tables which are tagged.
>
> Please let me know.
>
> Thanks,
> Elango
>
>

Re: Getting hive tables that are updated in last one week

Posted by JUSTIN KV <ju...@gmail.com>.
hi all any one suggest some company providing big data training in india,
kochi or any fresher job

On Mon, Mar 16, 2020 at 10:15 PM elango vaidyanathan <el...@gmail.com>
wrote:

>
>
> Hi all,
>
> I want to get the list of hive tables or dbs that are updated in last
> week? We use HDP 3.1 and postgres as hive metastore. Also using atlas for
> all hive tables which are tagged.
>
> Please let me know.
>
> Thanks,
> Elango
>
>