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

[#1]

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 

[#2]

Hi @dave22 

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