How can we check wheather table is external and internal in have and size of database.

mohammad_shamim — Fri, 24 Nov 2017 21:21:52 GMT

Re: How can we check wheather table is external and internal in have and size of database.

Shu_ashu — Sun, 18 Aug 2019 05:26:46 GMT

Do desc formatted on the table name,this command will display either the table is External (or) Managed and Location of the table.

hive# desc formatted <db-name>.<db-table-name>;

Check Size of the Database:-

bash# hdfs dfs -count -h -v <hdfs-location>

Example:-

In the above screenshot you can view

i ran desc formatted devrabbit table,

The table type is Managed table and the

location of the table is

/user/hdfs/hive

if you want to find the size of the above location then do

hdfs dfs -count -h -v /user/hdfs/hive

It will display the size of the directory.