Hi All, I'm trying to use Shared data architecture...
# questions-and-troubleshooting
m
Hi All, I'm trying to use Shared data architecture of StarRocks 4.0 connecting external hudi catalog with underlying metastore as hive metastore and the catalog is connected to Metabase. I could see tables getting synced to the UI for specific database but fields are not synced to Metabase. Also I found metabase trying to run this query to get the columns of the table
Copy code
SELECT TABLE_SCHEMA TABLE_CAT, NULL TABLE_SCHEM, TABLE_NAME, NON_UNIQUE, TABLE_SCHEMA INDEX_QUALIFIER, INDEX_NAME, 3 TYPE, SEQ_IN_INDEX ORDINAL_POSITION, COLUMN_NAME, COLLATION ASC_OR_DESC, CARDINALITY, NULL PAGES, NULL FILTER_CONDITION FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = database() AND TABLE_NAME = 'common_audit' ORDER BY NON_UNIQUE, TYPE, INDEX_NAME, ORDINAL_POSITION
but there is no data in the table INFORMATION_SCHEMA.STATISTICS from Hive. Is there a way we can sync the columsn to metabase from external catalog tables?
m
I'm not sure.
Copy code
<https://docs.starrocks.io/docs/data_source/catalog/hudi_catalog/#hive-metastore>

<https://docs.starrocks.io/docs/integrations/BI_integrations/Metabase/>
@LiJiao
m
Could someone check this please?