Getting the below error when tries to use the below calculation in Tableau.
calculation: RAWSQL_SPATIAL("xx",[Geometry])
Unable to complete action
Bad Connection: Tableau could not connect to the data source.
Error Code: FAB9A2C5
Code: 47. DB::Exception: Missing columns: 'xx' while processing query: 'SELECT ST_ForceCollection(ST_Collect(CAST(xx, 'geometry'))) AS clct:Calculation_859906113746243584:nk, 1.1 AS $__alias__0 FROM UmlautDAPDM.MV_test AS MV_test GROUP BY -1', required columns: 'xx'. (UNKNOWN_IDENTIFIER) (version 24.1.1.2048 (official build))
, server ClickHouseNode(addr=http:10.0.1.5:8123, db=default)@1797588162
Connector Class: clickhouse_jdbc, Version: 0.2.6
SELECT ST_ForceCollection(ST_Collect((xx)::geometry)) AS "clct:Calculation_859906113746243584:nk",
1.1000000000000001 AS "$alias0"
FROM "UmlautDAPDM"."MV_test" "MV_test"
GROUP BY 1.1000000000000001
Getting the below error when tries to use the below calculation in Tableau. calculation: RAWSQL_SPATIAL("xx",[Geometry])
Unable to complete action Bad Connection: Tableau could not connect to the data source. Error Code: FAB9A2C5 Code: 47. DB::Exception: Missing columns: 'xx' while processing query: 'SELECT ST_ForceCollection(ST_Collect(CAST(xx, 'geometry'))) AS
clct:Calculation_859906113746243584:nk, 1.1 AS$__alias__0FROM UmlautDAPDM.MV_test AS MV_test GROUP BY -1', required columns: 'xx'. (UNKNOWN_IDENTIFIER) (version 24.1.1.2048 (official build)) , server ClickHouseNode(addr=http:10.0.1.5:8123, db=default)@1797588162 Connector Class: clickhouse_jdbc, Version: 0.2.6 SELECT ST_ForceCollection(ST_Collect((xx)::geometry)) AS "clct:Calculation_859906113746243584:nk", 1.1000000000000001 AS "$alias0" FROM "UmlautDAPDM"."MV_test" "MV_test" GROUP BY 1.1000000000000001