New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Missing support of interval types #391

Open

Pavel-Strybuk opened this issue Aug 27, 2024 · 0 comments

Labels

Pavel-Strybuk commented Aug 27, 2024

Describe the bug

Missing support of interval types:

IntervalNanosecond
IntervalMicrosecond
IntervalMillisecond
IntervalSecond
IntervalMinute
IntervalHour
IntervalDay
IntervalWeek
IntervalMonth
IntervalQuarter
IntervalYear

https://clickhouse.com/docs/en/sql-reference/data-types/special-data-types/interval

Steps to reproduce

Execute select interval 30 day or other supported units (seconds, years, ..., see link above)

Expected behaviour

No errors

clickhouse-connect and/or ClickHouse server logs

ERROR:clickhouse_connect.datatypes.registry: -- [27/Aug/2024 13:16:44] - Unrecognized ClickHouse type base: IntervalDay name: IntervalDay

Configuration

Environment

clickhouse-connect version: 0.7.16
Python version: 3.11.9
Operating system: Fedora 40

ClickHouse server

ClickHouse Server version: 23.12.2.59

The text was updated successfully, but these errors were encountered:

Pavel-Strybuk added the bug label

genzgd added enhancement and removed bug labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment