i have a database with 10 tables. all 10 tables data is stored in different different locations. out of 10 tables, some are managed tables and some are external tables.
some tables location is /apps/hive/warehouse/
some tables location is /warehouse/hive/managed/
some tables location is /warehouse/hive/external/
is there any way to find out total size of the database with out go into each location and find the size, any alternative?