Hello All,
There discrepancy causing counts to dif...
# getting-startedb
busy-analyst-8258
06/14/2022, 8:04 PMHello All,
There discrepancy causing counts to differ for tables and DBs on MDH home page between datasets and platforms. how to identify what cause the difference ?
b
bulky-soccer-26729
06/14/2022, 8:08 PMhi Geetha! could you post a little more info about this issue here? on datahub's home page you're seeing numbers not add up between things that should? screenshots are also welcome
b
busy-analyst-8258
06/14/2022, 8:27 PMHello Chris Collins,
yes in the homepage
busy-analyst-8258
06/14/2022, 8:30 PMunder Explore your Metadata Dataset as 48.2K
under Platforms
oracle as 24.8K,Greenplum as 24.6k Sqlserver as 1.1k
so the dataset entities count and platform counts are not matching
b
bulky-soccer-26729
06/14/2022, 8:33 PMahh interesting. We've actually heard this before quite recently as well. Would you mind opening up a github issue here for this so we can ensure we have time to explore where these discrepancies are coming from? just know it's on our radar! I don't want to post any guesses I might have without digging further.
b
busy-analyst-8258
06/14/2022, 8:46 PMthanks for your reponse Chris Collins, Sure will open the github issue.
b
bulky-soccer-26729
06/14/2022, 8:54 PMthank you!
b
busy-analyst-8258
06/14/2022, 9:02 PMcreated the github issue A short description of the bug #5172
b
bulky-soccer-26729
06/14/2022, 9:02 PMamazing
b
big-carpet-38439
06/15/2022, 12:11 AMMost likely it’s because of Containers (databases, schemas) which are not accounted for in Datasets.
big-carpet-38439
06/15/2022, 12:11 AMI don’t think this is a bug
b
busy-analyst-8258
06/15/2022, 12:55 PMHello John Joyce, thanks for the input , can you please elaborate in details .
Thank you.
busy-analyst-8258
06/16/2022, 7:14 PMHello John Joyce,
busy-analyst-8258
06/16/2022, 7:16 PMas per your suggestion i have checked the counts for the Dataset and Platforms and got the difference, the difference is matching with the container counts , so the analysis is correct?
busy-analyst-8258
06/16/2022, 7:16 PMProd Dataset Count
Oracle 64376
Greenplum 13260
MSSQL 8490
total 86126
busy-analyst-8258
06/16/2022, 7:17 PMPlatform Count
Oracle Greenplum MSSQL
Dataset 64376 13260 8490
Container 3455 181 336
Total 67831 13441 8826
busy-analyst-8258
06/16/2022, 7:19 PMPlatform Count
Oracle Greenplum MSSQL
Dataset 64376 13260 8490
Container 3455 181 336
Total 67831 13441 8826
Grand Total : 90098
Difference: 3972
Container total= 3972
b
bulky-soccer-26729
06/16/2022, 7:19 PMthere we go that makes sense!
bulky-soccer-26729
06/16/2022, 7:19 PMthanks so much for looking into this Geetha
b
big-carpet-38439
06/16/2022, 7:21 PM@busy-analyst-8258 Trying to follow the above - are you saying that the total does not add up or does?
b
busy-analyst-8258
06/16/2022, 7:40 PMData set count matches with Platform count if we remove the containers from platform..
k
kind-dawn-17532
06/22/2022, 2:39 PM@big-carpet-38439 is this an intended behavior? If yes, do we want to clarify this in the UI and docs somewhere? This will create confusion for the users otherwise..