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

[#1]

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

[#2 · Accepted solution]

@Mohammad Shamim

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.