Skip to content
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.

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

ClickHouse plugin does not support UInt64 data type #332

Open
aku opened this issue Jun 13, 2024 · 0 comments
Open

ClickHouse plugin does not support UInt64 data type #332

aku opened this issue Jun 13, 2024 · 0 comments
Labels
bug Something isn't working kind/quick-win Seems to be quick to do

Comments

@aku
Copy link

aku commented Jun 13, 2024

Describe the issue

If you try to return a UInt64 column an error happens:

Data of type 'class com.clickhouse.data.value.UnsignedLong' for column '[REDACTED]' is not supported
java.lang.IllegalArgumentException: Data of type 'class com.clickhouse.data.value.UnsignedLong' for column '[REDACTED]' is not supported
	at io.kestra.plugin.jdbc.AbstractCellConverter.convert(AbstractCellConverter.java:81)
	at io.kestra.plugin.jdbc.clickhouse.ClickHouseCellConverter.convertCell(ClickHouseCellConverter.java:88)
	at io.kestra.plugin.jdbc.AbstractJdbcQuery.convertCell(AbstractJdbcQuery.java:189)
	at io.kestra.plugin.jdbc.AbstractJdbcQuery.mapResultSetToMap(AbstractJdbcQuery.java:182)
	at io.kestra.plugin.jdbc.AbstractJdbcQuery.fetchResult(AbstractJdbcQuery.java:140)
	at io.kestra.plugin.jdbc.AbstractJdbcQuery.run(AbstractJdbcQuery.java:102)
	at io.kestra.plugin.jdbc.clickhouse.Query.run(Query.java:58)
	at io.kestra.plugin.jdbc.clickhouse.Query.run(Query.java:21)
	at io.kestra.core.runners.WorkerTaskThread.doRun(WorkerTaskThread.java:77)
	at io.kestra.core.runners.AbstractWorkerThread.run(AbstractWorkerThread.java:56)

As a temporary solution I use toInt64 function to convert from UInt64 to Int64 but it would be nice if you can fix it.

Environment

  • Kestra Version: 0.17.1
  • Operating System (OS/Docker/Kubernetes): all
  • Java Version (if you don't run kestra in Docker):
@aku aku added the bug Something isn't working label Jun 13, 2024
@loicmathieu loicmathieu added the kind/quick-win Seems to be quick to do label Jun 13, 2024
@anna-geller anna-geller transferred this issue from kestra-io/kestra Jul 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working kind/quick-win Seems to be quick to do
Projects
Status: Backlog
Development

No branches or pull requests

2 participants