ClickHouse / ClickHouse/ClickHouse

Cassandra's TimeUUID & Clickhouse type conversion issue.

Open
#71,472 0 comments 0 reactions 0 assignees View on GitHub
comp-dictionary external
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

### Discussed in https://github.com/ClickHouse/ClickHouse/discussions/70355

Originally posted by **Dev-Hariharan** October 4, 2024
Creating cassandra source dictionary using DDL query in clickhouse, facing datatype issue, Coz, cassandra keyspace table has TIMEUUID type for this specific field. In clickhouse supports only UUID.

`SQL Error [53] [07000]: Code: 53. DB::Exception: Type mismatch for column entity_id : expected Cassandra type uuid: While executing Cassandra. (TYPE_MISMATCH) (version 24.9.1.3278 (official build))
, server ClickHouseNode [uri=http://localhost:8123/default, options={use_server_time_zone=false,use_time_zone=false}]@629049661`

Any Suggestions ?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.