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 ... View more