we are using clickhouse JDBC connecter to connect from tableau to clickhouse.
In tableau we use it as publish data source.
Unable to complete action
The connection to the data source might have been lost.
Error Code: FAB9A2C5
Error executing subquery id: "1151"
An error occurred while communicating with data source 'DATASOTCENAME'
Code: 47. DB::Exception: Unknown identifier 'measure0' in aggregate function 'min(measure0) AS $temp3_output'. (UNKNOWN_IDENTIFIER) (version 23.10.5.20 (official build))
, server ClickHouseNode [uri=http://clickhouse:8123/default, options={custom_http_params=join_use_nulls=1,session_id=tableau-jdbc-connector-1712144566986-27492351,typeMappings=UInt64=java.lang.String,UInt128=java.lang.String,Int128=java.lang.String,UInt256=java.lang.String,Int256=java.lang.String,socket_timeout=300000}]@270777070
DataServiceFailure
mshustov
commented
2 months ago
Hi
we are using clickhouse JDBC connecter to connect from tableau to clickhouse. In tableau we use it as publish data source.
Unable to complete action The connection to the data source might have been lost. Error Code: FAB9A2C5 Error executing subquery id: "1151" An error occurred while communicating with data source 'DATASOTCENAME' Code: 47. DB::Exception: Unknown identifier 'measure0' in aggregate function 'min(measure0) AS
$temp3_output'. (UNKNOWN_IDENTIFIER) (version 23.10.5.20 (official build)) , server ClickHouseNode [uri=http://clickhouse:8123/default, options={custom_http_params=join_use_nulls=1,session_id=tableau-jdbc-connector-1712144566986-27492351,typeMappings=UInt64=java.lang.String,UInt128=java.lang.String,Int128=java.lang.String,UInt256=java.lang.String,Int256=java.lang.String,socket_timeout=300000}]@270777070 DataServiceFailure