Skip to main content
kkanchu
Silver ⭐️⭐️⭐️
kkanchu
Silver ⭐️⭐️⭐️
January 12, 2019

Count total number of hive tables across all databases

  • October 5, 2026 at 9:02 AM
  • 2 replies
  • 3864 views
  • Translate All

The number can be found in the database which is used to store hive meta data.

If MySql is the backend db,

select count(*) from TBLS;

2 replies

kalo2013
kalo2013
Silver ⭐️
January 15, 2019

What is the meaning of writing this?

Translate
kkanchu
Silver ⭐️⭐️⭐️
kkanchuAuthor
Silver ⭐️⭐️⭐️
January 16, 2019

Do you mean what is the use/need ? If so, for anyone who is a platform admin, if they would like to know how many hive tables are there in all the hive DBs put together, this query can help them answer. This was asked by a customer in one of the calls we had and thought it would help others with similar request. There is also a similar thread as this, feel free to refer this.

Translate
Terms & ConditionsAccessibility statement