https://signoz.io logo
#support
Title
# support
p

Pierre

06/11/2023, 7:33 PM
Hi, I wanted to explore logs with Grafana log explorer but the clickhouse plugin requires a TimeField of type datetime to be auto detected. any idea why you are using ``timestamp` UInt64 CODEC(DoubleDelta, LZ4),` and not datetime ?
s

Srikanth Chekuri

06/12/2023, 12:55 AM
You can convert the epoch to datetime in ClickHouse using functions like
toDateTime
p

Pierre

06/12/2023, 5:45 AM
yes for custom queries, but wanted to use it in grafana Log Explore, cf this: https://github.com/grafana/clickhouse-datasource/issues/420