How can we check wheather table is external and internal in have and size of database.
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>
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
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.
View solution in original post