Support Questions
Find answers, ask questions, and share your expertise

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

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

1 ACCEPTED SOLUTION

Super Guru

@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:-

43708-hcc.png

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.

View solution in original post

1 REPLY 1

Super Guru

@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:-

43708-hcc.png

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.