clickhouse-java

clickhouse-java copied to clipboard

Cannot set null to non-nullable column but column set default value in DDL

1

version v.0.3.2-patch11 DDL ```sql create tabel test( test_int Int64 default 10, test_string String default 'n' ) ``` ```java // com.clickhouse.jdbc.internal.InputBasedPreparedStatement @Override public void addBatch() throws SQLException { ensureOpen(); ClickHouseConfig config...

ShortFinger

Is this library suitable to generate Native files?

2

Wondering if this library can be used to convert flat files (e.g. CSV) to Clickhouse Native format (without connecting to server)?

mikeTWC1984

DDL: ``` CREATE MATERIALIZED VIEW log.slog_columns ( `_namespace` LowCardinality(String), `app` LowCardinality(String), `_string_columns` SimpleAggregateFunction(groupUniqArrayArray, Array(String)), `_number_columns` SimpleAggregateFunction(groupUniqArrayArray, Array(String)), `_date` Date ) ENGINE = ReplicatedAggregatingMergeTree('/clickhouse/tables/{single_shard_cluster}/{single_shard}/log/.inner_id.17f49fce-b895-461c-97f4-9fceb895e61c', '{replica}') PARTITION BY toYYYYMMDD(_date) ORDER BY (_namespace,...

yandd

Create table with keyword "use_metadata_cache"

1

https://github.com/ClickHouse/ClickHouse/pull/32928 jdbc not support this keyword "use_metadata_cache" create table sql: ```sql CREATE TABLE IF NOT EXISTS default.xxx ( `timestamp` DateTime64(9,'UTC'), `xxx` UInt64 ) ENGINE = MergeTree PARTITION BY toYYYYMMDD(timestamp) ORDER...

fiend19961

Timestamp read from database is treated as if it was in JVM timezone

4

When reading a DateTime value I get a timestamp that is shifted back by my JVM timezone offset. Server is in UTC, JVM in Europe/Warsaw (UTC+2). When I try to...

piotrp

how can i insert data use grpc-client with lz4 Compression and with format RowBinary?

2

my code like this: ``` ClickHouseClient clickHouseClient = CkUtils.buildClient(node); ClickHouseRequest request = clickHouseClient.connect(node); Pair tableColumns = CkUtils.getTableColumns(request, "default", "test"); String columns = tableColumns.getKey().stream() .map(ClickHouseColumn::getColumnName) .collect(Collectors.joining(",")); Mutation mutation = request.copy() .write()...

DemonJun

Error flushing statements

1

### Describe the bug Every time I update the table, I do a full update (delete first and then insert) However, when executing insert statements recently, Error flushing statements often...

Evre-wuwy

Client SSL certificate usage in strict verification mode prevents from password-based SSL authentication

7

### Describe the bug When SSL verification mode is set to "strict" at both client and server sides and client's certifivate is provided, jdbc connection fails for users authenticated by...

gzhivilo

Bumps org.apache.commons:commons-compress from 1.23.0 to 1.26.0. [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a...

dependabot[bot]

Bumps [org.postgresql:postgresql](https://github.com/pgjdbc/pgjdbc) from 42.6.0 to 42.6.1. Changelog Sourced from org.postgresql:postgresql's changelog. Changelog Notable changes since version 42.0.0, read the complete History of Changes. The format is based on Keep a...

dependabot[bot]