impala tables to show table size/ user who created the table within a whole database

dave22 — Mon, 09 May 2022 10:32:52 GMT

hi all

I'm looking to create a table to show all table names and information within a database as im having capacity issues

something simple like

username,size,tablename,last updated date

hoping this is an easy ask but i had no luck so far

Re: impala tables to show table size/ user who created the table within a whole database

jAnshula — Thu, 29 Feb 2024 15:38:56 GMT

The table data is stored in a HDFS location, so you may consume information out of it

# hdfs dfs -du -s -h /path/to/database/

--> From here you can pick the owner of the path, which should be the username

--> sub folders/files are the tables within the database

--> The modification date can be used as the last updated date

--> size of the table can be picked using below command

# hdfs dfs -du -s -h/path/to/database/

Let us know if this helps