search

kestra-io / plugin-jdbc

https://kestra.io/plugins/
Apache License 2.0
10 stars 7 forks source link

ClickHouse plugin does not support Unsigned data types #331

Open aku opened 1 month ago

aku commented 1 month ago

Describe the issue

'class com.clickhouse.data.value.UnsignedByte' for column '[REDACTED]' is not supported

Related issue https://github.com/kestra-io/plugin-jdbc/issues/332

Please check that you support other ClickHouse data types.

Environment

anna-geller commented 1 month ago

Could you share a reproducer (example flow that generates that error)? It's difficult to help otherwise. thx in advance!

aku commented 1 month ago

@anna-geller 

  - id: clickhouse
    type: io.kestra.plugin.jdbc.clickhouse.Query
    url: [REDACTED]
    username:  [REDACTED]
    password:  [REDACTED]
    sql: |
      SELECT 
            toUInt8(1)
          , toUInt16(1)
          , toUInt32(1)
          , toUInt64(1)
          , toUInt128(1)
          , toUInt256(1)
    fetchOne: true