Ruslan Khaliullin

Out of memory with default settings while extracting data from 200M rows table in PostgreSQL

5

Hi, I have a trouble with JDBC Bridge. I am trying to execute create table query in ClickHouse with JDBC based on PostgreSQL datasource: ``` CREATE TABLE `16cd958e64e341429b41226d986201d6_etl_intermediate_factonlinesales` ENGINE =...

NullPointerException when executing a query with a JOIN to PostgreSQL.

1

Hi. I use clickhouse-jdbc-bridge with postgresql driver. Recently I have tried to execute query with JOIN, but found an error NullPointerException [here](https://github.com/ClickHouse/clickhouse-jdbc-bridge/blob/master/src/main/java/com/clickhouse/jdbcbridge/core/ByteBuffer.java#L644). It is easy to repeat a problem: 1....

Is it possible to speed up the processing?

2

Hi @zhicwu I've made simple comparison between different ways of creating table from remote PostgreSQL source: ``` create or replace table postgresql_jdbc_source engine = MergeTree order by tuple() as select...