Refreshing table structures for MySQL DB Engine

[Csongor Fagyal]

Hello,

I have noticed that when using the MySQL DB Engine, if a table/view structure is changed in MySQL (actually we are using MariaDB), it is not reflected in ClickHouse, unless:

- CH is restarted

or

- The DB is recreated in CH

Anybody knows any workaround for this?

Thank you,

- Cs.

[Dima Novik]

Hi,

This feature works this way by design. You can try to replace it with mysql table function if possible:
https://clickhouse.com/docs/en/sql-reference/table-functions/mysql

Best wishes,

Dmitrii