cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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!

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!