ClickHouse
Hi, I have a problem with ODBC using Tableau.
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_measure__1 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_measure__1), 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?
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?
Try using the driver via https://github.com/Altinity/clickhouse-tableau-connector-odbc