Filtere DB list in primary-meta-store

[Anil Thyagarajan]

Is it possible to filter the DB list in primary-meta-store? I tried the below, but still i get to see the tables not mapped in primary.

primary-meta-store:
access-control-type: READ_AND_WRITE_AND_CREATE_ON_DATABASE_WHITELIST
database-prefix: ''
latency: 0
name: primary
remote-meta-store-uris: thrift://127.0.0.1:9083
mapped-databases:
- userdatalake
writable-database-white-list:
- userdatalake
federated-meta-stores:
- access-control-type: READ_ONLY
database-prefix: waggle_prod_
latency: 0
mapped-databases:
- test
- users
name: waggle_prod
remote-meta-store-uris: thrift://10.25.10.10:9083

$ hive --hiveconf hive.metastore.uris=thrift://localhost:9083 -e "show databases;"
userdatalake
proddatalake
qedatalake

$ hive --hiveconf hive.metastore.uris=thrift://10.25.10.10:9083 -e "show databases;"
test
users
devdatalake
mldatalake

$ hive --hiveconf hive.metastore.uris=thrift://localhost:48869 -e "show databases;"
userdatalake
proddatalake
qedatalake
waggle_prod_test
waggle_prod_users

Is it possible for the above command to show only the filtered DB as below?
$ hive --hiveconf hive.metastore.uris=thrift://localhost:48869 -e "show databases;"
userdatalake
waggle_prod_test
waggle_prod_users

Only userdatalake from Primary should be visible.

Thanks,
Anil

[Ana Jalba]

Hi Anil,

Currently, mapped-databases doesn't do anything when used for the primary. This is one of the reasons why we don't list primary primary-meta-store.mapped-databases as a configuration option in the documentation.

We can see and add support for this. Please create an issue with this request and we'll look into it.

Thanks,
Ana