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
>
>