clickhouse-java

clickhouse-java copied to clipboard

JDBC Driver marks Nullable Column as non-nullable

12

Hello, This is my first question here, so apologies in advance if I missed any information and pls let me know if more info is needed. We have a table...

nym3r0s

How to create batch insert with columns list with clickhouse-http-client?

7

Hello, the question how to implements inserting process by butch to table by columns list. I have table: ```sql CREATE TABLE test.test ( a String, b String DEFAULT 'unknown', c...

serhii-m-prime

Query with id is already running. (QUERY_WITH_SAME_ID_IS_ALREADY_RUNNING)

10

### I queried with namedParameterJdbcTemplate in for loop. But sometimes driver prompts " Query with id = xxxxxx is already running. ### This is my code ```java IntStream .range(0, config.getPartitionCount())...

somemistake

I want to set null to non-nullable column, and the column set should use the default value in DDL(jdbc version 0.4.1)

9

table ddl: ```sql create table aiops_local_dev.aiops_collect_1 ( product String, service String, itf String, latency Float64 default inf ) engine = ReplicatedMergeTree('/clickhouse/tables/{layer}-{shard}/aiops_local_dev/aiops_collect_1', '{replica}') PARTITION BY toYYYYMMDD(time) PRIMARY KEY (product, service, itf)...

xlvchao

We utilize SqlBasedPreparedStatement for querying lists and subsequently transform the ResultSet into ClickHouseResultSet. During iteration over the result set using a while loop, we occasionally encounter the following exception. What...

pioneerjxf

Select before insert with condition 'where 0'

2

When inserting into a table via executeBatch, before insert, Select is raised (which apparently checks for the presence of the required columns in the table) with Where 0. Is it...

dearestman

Disable Object Reuse By Default

7

## Summary - Enabling object reuse by default has the potential to cause unforeseen bugs in user code. - When a user decides to pass a `Stream` back as a...

rickysaltzer

Cannot use ResultSet.getObject to retrieve java.sql.Date (JDBC specification violation?)

10

### Describe the bug At some point ClickHouse JDBC driver switched to using `java.time.` types to represent temporal values. While I salute this change and would prefer too to abandon...

LDVSOFT

### Describe the bug In some cases, when we define a column with a Multidimensional array, and we insert an empty array with less deapth than the original column. Attempting...

mzitnik

AutoCloseable ClickHouseClient and async execute

2

### Describe the bug This is not so much a bug as much as trying to understand how to use the ClickHouseClient properly in an asynchronous context. The `ClickHouseClient` is...

ahmedriza