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, unsupported column type: SimpleAggregateFunction(anyLast, Nullable(String)) #3284

Open
ermal-abiti opened this issue Apr 24, 2024 · 0 comments

Comments

@ermal-abiti
Copy link

ermal-abiti commented Apr 24, 2024

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0):
  • Driver: Clickhouse 24.1.5.6
  1. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):
  • TablePlus Version: 6.0.0 (Build 550)

Issue: I am getting an error unsupported column type: SimpleAggregateFunction(anyLast, Nullable(String)) which I think is 100% related to TablePlus only (using clickhouse-client works perfectly).

The steps to reproduce this issue:

  1. Create a new table that includes a field of type SimpleAggregateFunction (anyLast, Nullable(String))
CREATE TABLE testdb1.products_test
(
	`date` DateTime64,
	`productID` String,
	`price` SimpleAggregateFunction (anyLast, Nullable(String))
)
ENGINE = AggregatingMergeTree()
ORDER by (productID)
  1. Try to interact with already created table (query, insert ...) and it should throw this error
SELECT * testdb1.products_test

console:
Query 1 ERROR at Line 1: : unsupported column type: AggregateFunction(anyLast, Nullable(String))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant