Clickhouse asynchronous_insert_log table not visible

97 Views Asked by At

asynchronous_insert_log table is not there under system db in clickhouse. My config.xml contains below configuration by default:

<clickhouse>
<!-- Other settings -->
<asynchronous_insert_log>
        <database>system</database>
        <table>asynchronous_insert_log</table>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>1048576</max_size_rows>
        <reserved_size_rows>8192</reserved_size_rows>
        <buffer_size_rows_flush_threshold>524288</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
        <partition_by>event_date</partition_by>
        <ttl>event_date + INTERVAL 3 DAY</ttl>
    </asynchronous_insert_log>
<!-- Other settings -->
</clickhouse>

Clickhouse server is running inside docker. I tried setting async_insert to 1 and restarted the container. But there was no change.

Do I need to change anything to migrate this to database?

Clickhouse reference documentation: https://clickhouse.com/docs/en/operations/server-configuration-parameters/settings#server_configuration_parameters-asynchronous_insert_log

0

There are 0 best solutions below