Support Questions

Find answers, ask questions, and share your expertise

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

avatar
New Contributor

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 

1 REPLY 1

avatar
Expert Contributor

 

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