Stack Overflow
Stack Overflow

Questions tagged [clickhouse-client]

58 questions
0
votes
1 answer

ClickHouse Question For DB::Exception URL “XXX” is not allowed in config.xml

I use the remote function to import data from remote servers in another clickhouse cluster, when I use the sql like : INSERT INTO dataplugin.ods_stb_info_all_local SELECT…
minyan-xiao
  • 1
  • 2
0
votes
0 answers

Clickhouse sqlalchemy query for data in JSON returned object

The query for clickhouse data from python in json format returned an object. How to get data from this object. The query is directly working in clickhouse-client connections and query are given below: QUERY: def getdata(self): engine,…
Christo Johnson
  • 48
  • 4
0
votes
1 answer

Cat with --multiquery is not working when creating and inserting data into Temporary table clickhouse

I am running multiple queries using one session. I have to create a Temporary table and then I have to insert data from CSV to that file and after that, I have to insert data into a Permanent table. I have to run all of these queries in one session.…
Zunnurain Badar
  • 920
  • 2
  • 7
  • 28
0
votes
1 answer

Does clickhouse support quick retrieval of any column?

I tried to use clickhouse to store 4 billion data, deployed on a single machine, 48-core cpu and 256g memory, mechanical hard disk. My data has ten columns, and I want to quickly search any column through SQL statements, such as: select * from table…
datagic
  • 25
  • 7
0
votes
0 answers

Unknown field found while parsing JSONEachRow format Click house

I'm getting this error I'm inserting the data into the Clickhouse and i get this error because some of fields are null. Unknown error field: Code: 117. DB::Exception: Unknown field found while parsing JSONEachRow format: SharesStats: (at row 1):…
Noman
  • 594
  • 1
  • 18
0
votes
1 answer

/bin/sh: 1: clickhouse: Operation not permitted

I am creating Clickhouse docker image for version 21.8.11.4, Dockerfile gets build successfully but when I tried to run it using docker run command, it says /bin/sh: 1: exec: /usr/bin/clickhouse-server: Operation not…
aac
  • 574
  • 2
  • 6
  • 18
0
votes
0 answers

Possible to point Clickhouse Table to a specific File Path?

I am aiming at having a clickhouse table that is constantly updating rows and easy to export. I am considering having a Clickhouse table reference a path to a CSV file, similar to how dictionaries can reference an Absolute Path to a file under its…
ewcvis
  • 139
  • 2
  • 11
0
votes
1 answer

Clickhouse is not inserting new data into Materialized view

I have created a materialized view using this query CREATE MATERIALIZED VIEW db.top_ids_mv ( `date_time` DateTime, `id` String, `total` UInt64 ) ENGINE = SummingMergeTree ORDER BY (date_time, id) SETTINGS index_granularity = 8192 POPULATE…
Zunnurain Badar
  • 920
  • 2
  • 7
  • 28
0
votes
0 answers

Is the last inserted data available when SELECTing from a distributed table of *MergeTree family?

Can I be sure that the last inserted data is available in a distrubuted table (based on tables from *ReplicatedMergeTree family) after clickhouse return control after an INSERT request or NOT? Say, I have a local table like the next one: CREATE…
sergzach
  • 6,578
  • 7
  • 46
  • 84
0
votes
0 answers

Clickhouse results are showing null rows sometimes

I'm trying to process some IP data that we store on our clickhouse database. We have some users who have IPv6 addresses logged, and some people have multiple IP addresses logged, so what I am trying to achieve is to get only the IPv4 addresses, and…
ewcvis
  • 139
  • 2
  • 11
0
votes
2 answers

Issues with loading Maxmind Data into Clickhouse Database using a local file

I'm trying to insert Maxmind Data into a Clickhouse Dictionary but defining it source as a local file where I can running my Client from. so to define my dictionary I use the query: CREATE DICTIONARY usage_analytics.city_locations( geoname_id…
ewcvis
  • 139
  • 2
  • 11
-1
votes
1 answer

Clickhouse-client insert optimization

I'm inserting a lot of CSV data files into remote Clickhouse database that already has a lot of data. I'm doing it using simple script like this: ... for j in *.csv; do clickhouse-client --max_insert_threads=32 --receive_timeout=30000…
Arzybek
  • 547
  • 2
  • 6
  • 27
1 2 3
4