clickhouse-mysql-data-reader

clickhouse-mysql-data-reader copied to clipboard

[WIP] Feature/add update delete support

3

ygnuss

The JSON type of mysql generates an error when importing incremental data. CRITICAL:ex='dict' object has no attribute 'encode'. When importing full data, the mysql JSON type does not report errors

mylqf

TODO: Update description

Tazer

trying to import data from mysql but failing

2

I have configured both mysql and clickhouse, when I try to import data I get the following error: ``` 2021-04-27 12:08:01,107/1619507281.107731:DEBUG:class: insert 1 event(s) 2021-04-27 12:08:01,481/1619507281.481600:DEBUG:class: insert 100000 row(s) 2021-04-27...

aminbaig

While trying to import data from mysql table to clickhouse, the execution stops with this error: ``` VALUES 2021-06-18 22:58:56,737/1624057136.737545:DEBUG:Block "" send time: 0.000042 2021-06-18 22:59:40,788/1624057180.788412:DEBUG:Block "" send time: 37.195755...

fabioaraujopt

clickhouse-mysql is unable to read tables with double underscores in their name like "3by1_test_20aug19__23" it is failing with this "CRITICAL:sequence item 0: expected str instance, NoneType found"

big4test4

Using logrotate on Ubuntu this could be achieved. I noticed clickhouse-mysql does not do it by itself. Create file **/etc/logrotate.d/clickhouse-mysql** and add ``` /path/to//your/log/from/config { daily create 0644 root root...

sv3t0sl4v

awesome oss! There is a question: due to some businiess reasons, we have to migrate two or three tables from mysql to one table. The mappings between fields of these...

SE2AI

Select query with multiple joins won't work

1

I need some help. I have managed to migrate some of MySQL 5.1 tables to Clickhouse. Basic select query works fine with 1 inner join. However I noticed if I...

ericchuawc

Connection via proxysql

6

Is there way to work through a proxysql ? The standart schema is clickhouse ---> proxysql ---> mysql master 1

shafiev