clickhouse-java
clickhouse-java copied to clipboard
ClickHouse
Java client and JDBC driver for ClickHouse
I have a table with aggregatingMergeTree engine, like: ```sql CREATE TABLE db2.agg_dcc1_local ON CLUSTER ck_default_cluster( id String, city String, codeUniq AggregateFunction(uniq,String), codeCount AggregateFunction(count,String), valueSum AggregateFunction(sum,Int32), valueMin AggregateFunction(min,Int32), valueMax AggregateFunction(max,Int32), valueAvg...
Fix for ClickHouseTabSeparatedProcessor with extremes and/or totals.
https://github.com/ClickHouse/clickhouse-jdbc/blob/c98c084e35ee68249274fcd273644545d90e82a3/clickhouse-jdbc/src/main/java/com/clickhouse/jdbc/internal/ClickHouseConnectionImpl.java#L279-L282 The `GregorianCalendar` object is created using local default time zone, not server time zone.
### Background ClickHouse supports clustering and often runs in a cluster. Typical approaches for load balancing and failover are: * distributed table * proxy/gateway(e.g. chproxy, traefik etc.) sitting between client...
**Use case** 1. I want to run the clickhouse jdbc drivers inside an OSGi Framework. 2. I would like to use the OSGi -pecifies DatasourceFactory. **Describe the solution you'd like**...
When doing an execute on an insert prepared statement, I get what feels like a compatability error? ``` java.sql.BatchUpdateException: Reached end of input stream after reading 23 of 32 bytes,...
**Table DDL** ```sql CREATE TABLE EXAMPLE ( id Int64, date DateTime64, number Int64 DEFAULT -1 ) ENGINE = MergeTree ORDER BY (id); ``` -------- From ClickHouse's [documentation](https://clickhouse.com/docs/en/sql-reference/statements/insert-into/#insert), looking to specify...
```java public static void main(String[] args) throws SQLException { final String DB_URL = "jdbc:clickhouse://github.demo.trial.altinity.cloud:8443?&ssl=true"; final String USER = "demo"; final String PASS = "demo"; final String QUERY = "SELECT count()...
Minimal example: ``` 2022.04.05 21:26:58,791 [main] WARN [] com.clickhouse.jdbc.parser.ClickHouseSqlParser - Parse error at line 1, column 15. Encountered: :2. If you believe the SQL is valid, please feel free to...
[WARN] [main] ru.yandex.clickhouse.jdbc.parser.ClickHouseSqlParser - Lexical error at line 2, column 38. Encountered: "\u8fc7" (36807), after : "". If you believe the SQL is valid, please feel free to open an...
