Error retrieving alias columns - ClickHouse 23.8

[subkanthi]

Error retrieving alias columns in 2.4.1

2024-11-22 16:47:25.624 ERROR - *** TABLE METADATA not retrieved for Database(db), table(event) retrying
2024-11-22 16:47:25.624 INFO  - *************** EXECUTED BATCH Successfully Records: 1192************** task(0) Thread ID: Sink Connector thread-pool-7 Result: [I@937031c Database: db Table: rjt
2024-11-22 16:47:25.624 ERROR - Error getting alias columns
java.lang.NullPointerException: null
2024-11-22 16:47:25.624 ERROR - Error with DB connection
2024-11-22 16:47:25.624 ERROR - Error with DB connection
2024-11-22 16:47:25.624 ERROR - Error with DB connection

[subkanthi]

Cannot reproduce error
with

Connected to ClickHouse server version 23.8.5 revision 54465.

[subkanthi]

9d26a6f6e615 :) select query,exception_code from system.query_log where query like '%MATERIALIZED%' and exception_code != 0;

SELECT
    query,
    exception_code
FROM system.query_log
WHERE (query LIKE '%MATERIALIZED%') AND (exception_code != 0)

Query id: a578e155-8ec6-488d-b216-77e5574c49b5

Ok.

0 rows in set. Elapsed: 0.004 sec. Processed 8.82 thousand rows, 1.52 MB (2.51 million rows/s., 431.90 MB/s.)
Peak memory usage: 1.11 MiB.

[subkanthi]

9d26a6f6e615 :) select query,exception_code from system.query_log where query like '%MATERIALIZED%';

SELECT
    query,
    exception_code
FROM system.query_log
WHERE query LIKE '%MATERIALIZED%'

Query id: 459d0378-3f88-4273-9929-94f2bf70e3f8

┌─query──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬─exception_code─┐
│ CREATE TABLE if not exists altinity_sink_connector.replica_source_info ( `id` String, `offset_key` String, `offset_val` String, `record_insert_ts` DateTime, `record_insert_seq` UInt64, `_version` UInt64 MATERIALIZED toUnixTimestamp64Nano(now64(9)) ) ENGINE = ReplacingMergeTree(_version) ORDER BY offset_key SETTINGS index_granularity = 8192 │              0 │
│ CREATE TABLE if not exists altinity_sink_connector.replica_source_info ( `id` String, `offset_key` String, `offset_val` String, `record_insert_ts` DateTime, `record_insert_seq` UInt64, `_version` UInt64 MATERIALIZED toUnixTimestamp64Nano(now64(9)) ) ENGINE = ReplacingMergeTree(_version) ORDER BY offset_key SETTINGS index_granularity = 8192 │              0 │
│ SELECT name FROM system.columns WHERE (table = 'sbtest1') AND (database = 'chtest') and (default_kind='ALIAS' or default_kind='MATERIALIZED')