clickhouse-java

clickhouse-java copied to clipboard

Failed to parse 'CASE WHEN' condition expression without brackets

1

I had the following SQL statment: ``` SELECT CASE WHEN "metrics_all"."METRIC_ID" IS NULL OR "metrics_all"."SUB_METRIC" IS NULL THEN NULL WHEN "metrics_all"."METRIC_ID" > "metrics_all"."SUB_METRIC" THEN "metrics_all"."METRIC_ID" ELSE "metrics_all"."SUB_METRIC" END AS "MET"...

chenyele

Implement setClientInfo

3

Feature request: implement `java.sql.Connection#setClientInfo` (and `ClickHouseDatabaseMetaData#getClientInfoProperties`) That would allow to pass some useful metadata to database, eg. frontend user that initiated current query, which would be then accessible in query_log....

piotrp

Noticed internal JDBC error in DBeaver when cancel multi-statement query. ``` java.lang.ArrayIndexOutOfBoundsException: Index 8 out of bounds for length 1 at ru.yandex.clickhouse.ClickHouseStatementImpl.getLastInputStream(ClickHouseStatementImpl.java:691) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:340) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:324) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:319) at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:314)...

zhicwu

Why query parsing is mandatory?

6

Hi. What is the rationale for making SQL parsing mandatory? Event though parser is lightweight, it definitely adds latency especially in case of lengthy SQL, Adds up to ~100ms for...

x052bb

Parse exception warning

3

After upgrading to 0.2.6 I see the following warning in the log: `Failed to parse the given SQL. If you believe the SQL is valid, please feel free to open...

alniks

javacc parser is very slow to parse sql

10

I executed a batch insert SQL, but the execution was very slow. I took a look at Flame Graph and the sql parsing took most of the time. I looked...

holmofy

Recommended config settings for large selects

2

I'm running a large select over a single table and have noticed that at around 300k rows, the driver just returns an empty resultset with no error thrown, while anything...

HunterSherms

Received fatal alert: certificate_required

1

I'm trying set ssl connect to clickhouse server which hosted on VPS. I can connect to ClickHouse by [this](https://www.npmjs.com/package/clickhouse) nodejs lib with my certificate, but in DBeaver I got error...

TimonKK

Slow deserialization of DateTime values

2

Deserialization of DateTime value seems very slow comparing to string and number. Below are benchmarks against ClickHouse 21.8. ``` Benchmark (client) (connection) (statement) Mode Cnt Score Error Units Query.select10kStringRows clickhouse-jdbc(0.3.1-patch)...

zhicwu

PreparedStatement executeBatch returns number of rows regardless on how many failed

1

`executeBatch()` method does return an `int[]` that seems to be filled with all ones regardless on many of the rows in the `PreparedStatement` went well. Reference: https://github.com/yandex/clickhouse-jdbc/blob/master/src/main/java/ru/yandex/clickhouse/ClickHousePreparedStatementImpl.java#L365 Is there any...

jorge-lavin