Category "clickhouse"

Data caching with ClickHouse

Intro I have ClickHouse as data warehouse (tables with billions of rows). Users interact with the DWH using my application backend that generates SQL queries to

ClickHouse connection refused after shut down Linux OS (error Code: 210. DB::NetException: Connection refused)

I saw a previous post on StackOverflow related to my question. I tried to handle this connection problem by entering sudo nano /etc/clickhouse-server/config.xml

Clickhouse Kafka engine on cluster

I'm playing with Kafka engine on ClickHouse cluster. At the moment ClickHouse 22.1 cluster and Kafka are run in Docker. Here are configurations: https://github.

How initialize the result of groupArray function of the ClickHouse to the array

In my Go application, I make a request to the ClickHouse database via clickhouse-go package. This query which I make return always only one record and it's an a

creating db and tables in a dockerized Clickhouse instance from docker-compose file

My requirement is to create DB and Tables in Clickhouse when I'm bringing it up using docker-compose. If it is mysql, I do it as below : mysql_1: image:

insert decimal type to clickhouse database , there have error of unexpected type string

I am a beginner, I don't understand why insert decimal type field "money", it echo "money (Decimal(18, 2)): unexpected type string" func main() { dsn := "