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

Count all db, tables and partitions in hive

Count all db, tables and partitions in hive

New Contributor

Hi

I need to know how many bases, tables and partitions we have in hive. Taking into account that the cluster has more than 10,000 bases, it is ruled out to do it manually.

 

Please could you tell me if it can be done by querry and how to do it?

 

Thank you!

Greetings.

 

Hernan.

1 REPLY 1

Re: Count all db, tables and partitions in hive

Expert Contributor

Hello

 

You have the following commands from hive

 

show databases

show tables

show partitions <dbName>.<tableName>;

 

You can write your script to count, one example, count number of tables

 

hive -e "show databases" >db3.out;cat db3.out | while read line; do hive -e "use $line;show tables" >> tables3.out;done; cat tables3.out | wc -l

 

PS: there maybe some unwanted characters, you may want to do some cleaning up before final count