cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Display count of records in all tables in hive meta store based on one of the column value.

DBX-Beginer
New Contributor

I have a DB name called Test in Hive meta store of data bricks. This DB contains around 100 tables. Each table has the column name called sourcesystem and many other columns. Now I need to display the count of records in each table group by source system.

Display the data as bellow.

Tablename, sourceystem, record_count

SQL query for the same for single table:

Select count(*),sourceystem from test.sales GROUP BY sourceystem

2 REPLIES 2

Lakshay
Esteemed Contributor
Esteemed Contributor

Hi @Krish K​ , You need to run the iteration over the list of tables in "Test" DB. We can't query all the tables at once.

Anonymous
Not applicable

Hi @Krish K​ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.