UnamedRus

Non-primitive data types in table schema.

2

Ability to use non-primitive data types in table column definition. As i understand current workaround is to use `Pickle, Unpickle` functions with String data type, but it's inconvenient. For example,...

Feature Request: INSERT INTO without explicit column list in table definition.

2

If amount of columns being inserted and order match order in table definition, you can skip defining list of columns after table name.

Feature request: SHOW CREATE TABLE

3

Ability to get CREATE TABLE statement in easy way.

OracleDB doesn't allow to have more than 1 LONG column (It's big string datatype in Oracle) https://stackoverflow.com/questions/11646124/how-i-can-create-a-table-having-two-long-columns And for ``` INSERT INTO oracle_table SELECT * FROM clickhouse_table ``` OracleDB run...

Ability to define multiple hosts, which can be used by odbc driver for load balancing or HA. Like for clickhouse-jdbc https://github.com/ClickHouse/clickhouse-jdbc/blob/c80b60bd81d1ad98e7a140590ef95f12ee6021d0/clickhouse-jdbc/src/test/java/ru/yandex/clickhouse/BalancedClickhouseDataSourceTest.java#L31 vertica-odbc https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/ConnectingToVertica/ClientODBC/ODBCConnectionFailover.htm (backup host) cassandra-odbc https://docs.informatica.com/data-integration/powerexchange-adapters-for-powercenter/10-2/powerexchange-for-cassandra-user-guide-for-powercenter/powerexchange-for-cassandra-configuration/configuring-the-cassandra-odbc-advanced-properties-for-data-sour/cassandra-odbc-data-source-name-advanced-properties.html ( Whitelist hosts...

From PostgreSQL docs: ``` without any precision or scale creates an “unconstrained numeric” column in which numeric values of any length can be stored, up to the implementation limits. A...

wrong pushdown of id.null to table engine non nullable column (null type is generated in JOIN), `allow_experimental_analyzer, optimize_functions_to_subcolumns, join_use_nulls`

1

> You have to provide the following information whenever possible. **Describe what's wrong** 24.1 https://fiddle.clickhouse.com/dd0a8814-e878-41f1-a233-9adff3b52e57 23.1 https://fiddle.clickhouse.com/dd0a8814-e878-41f1-a233-9adff3b52e57 ``` CREATE TABLE test (id UInt64) ENGINE=MergeTree ORDER BY tuple(); INSERT INTO test...

> You have to provide the following information whenever possible. **Describe what's wrong** 24.1 https://fiddle.clickhouse.com/5ada3a58-e2ea-4547-8abf-cd8888cf8cc8 23.3 https://fiddle.clickhouse.com/2672375c-0bda-49b3-865e-6004c004e281 working correctly ``` WITH ws_wh AS ( SELECT ws1.ws_order_number FROM ( SELECT 1...

Condition pushdown: Window function is found in HAVING in query.

2

**Describe what's wrong** ClickHouse pushdown condition for Window Function **Does it reproduce on recent release?** Yes, 23.2 ``` LAPTOP-. :) SELECT * FROM (SELECT dense_rank() OVER (ORDER BY number DESC)...

Keeper support for readiness endpoint (manifests)

11

> ClickHouse Keeper provides an HTTP interface to check if a replica is ready to receive traffic. It may be used in cloud environments, such as [Kubernetes](https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-startup-probes/#define-readiness-probes). https://github.com/ClickHouse/ClickHouse/pull/55876 https://github.com/ClickHouse/clickhouse-docs/pull/1767/files#diff-a3037a0357709df221a285b2b5ca2df68b3f7d95e795f7409c594be469daf8a0R363