clickhouse Questions
3
I have two tables
event
id
os
params
id
sx
sy
This table have relation 1-1 by id. If execute query
select count(*)
from
(select id from event where os like 'Android%')
inner join
(select ...
Launcher asked 2/11, 2016 at 12:26
1
I am using Spring JPA with hibernate ORM project and want to integrate with ClickHouse.
I found some references of ClickHouse JDBC which is working
ClickHouseJDBCDemo ClickHouseJDBCDemo
but was...
Roswald asked 2/3, 2018 at 13:41
2
Solved
so I created a table using clickhouse, but it has duplicates in it.
The following query gives me the duplicates in my table
select *, count() AS cnt from my_table GROUP BY *
HAVING cnt > 1
In ...
Komsomolsk asked 31/3, 2022 at 3:31
3
Solved
I'm running Clickhouse in a docker container on a Windows host. I tried to create an account towards making it an admin account. It looks like the default user does not have permission to create ot...
Voss asked 2/10, 2020 at 5:17
3
I am having an issue connecting to clickhouse in a windows docker container with python's driver. Clickhouse server is running on my E drive in a docker container exposed to port 8123. I can connec...
Turgid asked 3/9, 2019 at 20:54
6
I went over the documentation for Clickhouse and I did not see the option to UPDATE nor DELETE. It seems to me its an append only system.
Is there a possibility to update existing records or is the...
Watchmaker asked 18/6, 2016 at 21:7
3
Solved
We are revamping our existing system, which uses MYSQL DB to deal with the following type of data.
transaction and order related data
customers information
products information
We need to query...
Blandishments asked 5/4, 2019 at 12:47
2
I've 3 node cluster with replication 2 and the replicated table stats.
Recently saw that there is a delay on the replica db using /replica_satatus
db.stats: Absolute delay: 0. Relative delay: 0.
...
Dart asked 30/6, 2018 at 8:38
2
Solved
Clickhouse can definitely read JSON messages from Kafka if they are flat JSON documents.
We indicate this with kafka_format = 'JSONEachRow' in Clickhouse.
This is the way we currently using it:
CRE...
Urtication asked 21/8, 2020 at 18:30
4
Solved
I have installed clickhouse as per the instructions here https://github.com/Altinity/clickhouse-rpm-install.
I have also enabled :: in /etc/clickhouse-server/config.xml.
It started fine as below:...
Gris asked 23/5, 2018 at 14:8
2
Solved
Is it possible to alter a table engine in clickhouse table like in MySQL, something like this:
CREATE TABLE example_table (id UInt32, data String) ENGINE=MergeTree() ORDER BY id;
ALTER example_tabl...
Syringomyelia asked 9/8, 2021 at 17:31
2
Solved
I'm trying to add JSON data to ClickHouse from Kafka. Here's simplified JSON:
{
...
"sendAddress":{
"sendCommChannelTypeId":4,
"sendCommChannelTypeCode":"SMS&...
Saphena asked 2/12, 2020 at 7:51
3
Solved
I want to import from MySQL dump to Clickhouse. I've tried going through the official docs but cannot find anything. I've tried importing using CSV following Stack Overflow answer. Any help appreci...
Flying asked 8/12, 2017 at 5:45
4
While trying to install ClickHouse in a macOS Catalina, doing the following command:
➜ ~ curl -O 'https://builds.clickhouse.tech/master/macos/clickhouse' && chmod a+x ./clickhouse
After try...
Plumy asked 25/8, 2021 at 12:0
1
Solved
I need to wait for Clickhouse to start before I can start my backend server, however the healthcheck does not work.
Here is my docker-compose.yml file:
version: '3.9'
services:
server:
build: .
...
Dichotomous asked 11/8, 2022 at 19:12
3
Is there any way to ALTER a table and change the column name in clickhouse?
I only found to change tha table name but not for an individual column in a straight forward way.
Thanks.
Gadgeteer asked 17/11, 2017 at 11:42
4
unable to connect to the client,following is the error
root@abcC:~# clickhouse-server client ClickHouse client version
20.1.4.14 (official build). Connecting to localhost:9000 as user default.
**C...
Eggplant asked 18/2, 2020 at 14:35
1
Solved
I'm trying to change /var/lib/clickhouse to something like /mnt/sdc/clickhouse so that i could have clickhouse in another hard disk. I've tried this steps:
1. Stop Clickhouse
2. Move directory /...
Quick asked 29/9, 2021 at 6:27
5
Solved
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: mysql:5.7.16
environment:
MYSQL_DATABASE...
Causeuse asked 6/9, 2018 at 6:52
2
Solved
I'm going to migrate data from PostgreSQL database to Yandex's ClickHouse.
One of the fields in a source table is of type JSON - called additional_data. So, PostgreSQL allows me to access json attr...
Merited asked 30/9, 2020 at 6:19
2
Solved
I have a simple table:
CREATE TABLE t1
(
v1 Int32,
a1 Array(Int32),
s2 Array(String)
) ENGINE = Memory
but can't figure out how to insert String array:
insert into t1 format CSV 1,"[1,2]",...
Gyratory asked 6/9, 2016 at 15:3
1
Solved
(I am trying to copy a 7m row table from PostgreSQL to ClickHouse)
I'm running Postgres in Docker and copying to a tab separated variable dump file with:
docker exec -it db psql -U db_user db_name ...
Bangkok asked 21/1, 2022 at 19:53
2
Solved
I'm using the Data Skipping Indexes feature in clickhouse and i got confused about its usage. If i add a data skip index when i create the table like this:
CREATE TABLE MyTable
(
...
INDEX index...
Alost asked 29/8, 2019 at 10:54
2
Solved
LowCardinality fields in ClickHouse are an optimization where the values are dictionary-encoded for faster lookups and smaller storage. As per documentation:
The efficiency of using LowCarditali...
Insanitary asked 11/6, 2020 at 15:30
3
Solved
I'm running ClickHouse Docker image on MacBook M1 and getting the following error.
clickhouse-02_1 | runtime: failed to create new OS thread (have 2 already; errno=22)
clickhouse-02_1 | fa...
Delciedelcina asked 2/11, 2021 at 11:16
1 Next >
© 2022 - 2024 — McMap. All rights reserved.