gaoxingliang commented on issue #8828:
URL: https://github.com/apache/apisix/issues/8828#issuecomment-1427267685
@An-DJ
My clickhouse conf:
```
{
"user": "xxxx",
"password": "xxxx",
"database": "default",
"logtable": "api_log3",
"endpoint_addr": "http://clickhouse-clickhouse.xxxx:8123/";,
"batch_max_size": 500,
"buffer_duration": 180,
"max_retry_count": 5,
"retry_delay": 10
}
```
and my table:
```
-- I changed the response column by adding a default value and the error
seems disapperaed:
create table api_log3 on cluster "all-nodes" (
upstream String,
start_time DateTime64(3, 'Asia/Shanghai'),
client_ip String,
service_id String,
route_id String,
request JSON,
response JSON DEFAULT '{}',
server JSON,
latency Float64,
upstream_latency Float64,
apisix_latency Float64
)
ENGINE =
ReplicatedMergeTree('/clickhouse/tables/{shard}/{database}/{table}',
'{replica}')
PARTITION BY toYYYYMM(start_time)
ORDER BY (start_time, route_id);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
