search

ClickHouse / clickhouse-tableau-connector-jdbc

Tableau connector to ClickHouse using JDBC driver
Apache License 2.0
57 stars 9 forks source link

DateTime('UTC') is not recognized as timestamp in Tableau #39

Open vlauzeckas opened 1 year ago

vlauzeckas commented 1 year ago

Not sure it issue with the connector or JDBC driver itself, but i noticed strange behavior:

Add such query as custom SQL: select toDateTime('2022-08-23 02:52:53') as tz, toTypeName(tz) as tz_type, toDateTime('2022-08-23 02:52:53', 'UTC') as tz_utc, toTypeName(tz_utc) as tz_utc_type

tz_utc - is not recognized as Timesstamp in tableau. You can change it on tableau level, but that would add huge overhead of casting string to datetime.

image

yurifal commented 1 year ago

hi @vlauzeckas it looks like Tableau doesn't read the timezone Metadata from the [tz_utc] column, so it couldn't recognise the data type "DateTime with timezone" (it would return NULL as evident in Describe).

vlauzeckas commented 1 year ago

but thats a bit of a problem. if data type "DateTime with timezone" tableau does not recognize. you can force it to cast, but that's big overhead and lead to not optimal queries.

yurifal commented 1 year ago

I understand, but have neither a fix nor a workaround (other than obvious CASTing), sorry.

gonchik commented 1 year ago

@yurifal how does it works previously? :) We met after upgrading driver and platform Tableau.

@vlauzeckas did you met after upgrade driver or after upgrading Tableau? It so, maybe we have to together escalate to the Tableau ? :)

yurifal commented 1 year ago

@gonchik how does it works previously? :) it doesn't work (and it had not been working as far as I'm aware of).

gonchik commented 1 year ago

@yurifal Noted, let me push back the BI team :) Thanks for the fast response

yurifal commented 1 year ago

@gonchik you're welcome.

vlauzeckas commented 1 year ago

@yurifal how does it works previously? :) We met after upgrading driver and platform Tableau.

@vlauzeckas did you met after upgrade driver or after upgrading Tableau? It so, maybe we have to together escalate to the Tableau ? :)

Sorry, where did i mentioned upgrade?:)

gonchik commented 1 year ago

@vlauzeckas it's my mistake, it's a pity that I failed the exam in clairvoyance. I found that one after upgrades that's why I have asked

silentsokolov commented 4 months ago

Any news? The same problem

Tableau Desktop v2023.3.x (and WebView on Server v2023.3.x) ClickHouse v23.8.2.7 clickhouse-tableau-connector-jdbc v0.2.6 Clickhouse JDBC driver: 0.6.0