Hi, I have a problem with ODBC using Tableau.

[qazqaz44944]

Hi, I have a problem with ODBC using Tableau. clickhouse-server-21.1.2.15-2 Outcoming query:

HTTP status code: 404 Received error: Code: 47, e.displayText() = DB::Exception: Unknown identifier: X_measure1 there are columns: MEMBERID, ACTIONTIME, 'DATE', cast(ACTIONTIME, 'DATE'): While processing multiIf(cast(ACTIONTIME, 'DATE') > X_measure__1, cast(ACTIONTIME, 'DATE'), NOT (cast(ACTIONTIME, 'DATE') > X_measure1), NULL, NULL) (version 21.1.2.15 (official build)) SELECT {fn TIMESTAMPDIFF(SQL_TSI_QUARTER,t1.X_measure__1,t1.X_measure__3)} AS Calculation_299770854823833620, COUNT(DISTINCT FGL.MEMBERID) AS ctd_MEMBERID_ok, {fn QUARTER(t1.X_measure__1)} AS qr_Calculation_299770854823596050_ok, CAST({fn TRUNCATE(EXTRACT(YEAR FROM t1.X_measure__1),0)} AS INTEGER) AS yr_Calculation_299770854823596050_ok FROM FGL INNER JOIN ( SELECT FGL.MEMBERID AS MEMBERID, MIN(CAST(FGL.ACTIONTIME AS DATE)) AS X_measure__1, MIN((CASE WHEN (CAST(FGL.ACTIONTIME AS DATE) > t0.X_measure__1) THEN CAST(FGL.ACTIONTIME AS DATE) WHEN NOT (CAST(FGL.ACTIONTIME AS DATE) > t0.X_measure__1) THEN NULL ELSE NULL END)) AS X_measure__3 FROM FGL INNER JOIN ( SELECT FGL.MEMBERID AS MEMBERID, MIN(CAST(FGL.ACTIONTIME AS DATE)) AS X_measure__1 FROM FGL GROUP BY MEMBERID ) t0 ON (FGL.MEMBERID = t0.MEMBERID) GROUP BY MEMBERID ) t1 ON (FGL.MEMBERID = t1.MEMBERID) WHERE (FGL.SHOPID = '01005') GROUP BY Calculation_299770854823833620, qr_Calculation_299770854823596050_ok, yr_Calculation_299770854823596050_ok Can you fix it?

[traceon]

This is an error from ClickHouse server. It says id doesn't know what X_measure__1 is. Do you have such column? Who put it in the query, you or Tableau?

[qazqaz44944]

Tableau

[traceon]

Try using the driver via https://github.com/Altinity/clickhouse-tableau-connector-odbc