You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have tried your new connector with the hope it would correct limitations because Tableau does not understand the ClickHouse SQL dialect.
Before I had a several limitations and issues with JOIN ON syntax and LOD expressions as FIXED, INCLUDE etc.
for example :
Une erreur s'est produite lors de la communication avec la source de données Autres bases de données (ODBC) 'qoe_fixe'
Problème de connexion : Tableau n'a pas pu se connecter à la source de données.
Code d'erreur : B19090E0
HTTP status code: 501
Received error:
Code: 48, e.displayText() = DB::Exception: JOIN ON does not support OR. Unexpected '(zipcode = t0.zipcode) OR (isNull(zipcode) AND isNull(t0.zipcode))': While processing (zipcode = t0.zipcode) OR (isNull(zipcode) AND isNull(t0.zipcode)) (version 21.3.15.4 (official build))
but there were no errors displayed on calculated fields, even if they were based on "sets" etc..
Now, If I used your new connector, I encounter another problem: It seems that "sets" are not recognised??
For exemple :
In this calculated field I use a set called « Dsl_Indispo_One_Day »
Hi,
I have tried your new connector with the hope it would correct limitations because Tableau does not understand the ClickHouse SQL dialect.
Before I had a several limitations and issues with JOIN ON syntax and LOD expressions as FIXED, INCLUDE etc.
for example :
Une erreur s'est produite lors de la communication avec la source de données Autres bases de données (ODBC) 'qoe_fixe'
Problème de connexion : Tableau n'a pas pu se connecter à la source de données.
Code d'erreur : B19090E0
HTTP status code: 501
Received error:
Code: 48, e.displayText() = DB::Exception: JOIN ON does not support OR. Unexpected '(zipcode = t0.zipcode) OR (isNull(zipcode) AND isNull(t0.zipcode))': While processing (zipcode = t0.zipcode) OR (isNull(zipcode) AND isNull(t0.zipcode)) (version 21.3.15.4 (official build))
but there were no errors displayed on calculated fields, even if they were based on "sets" etc..
Now, If I used your new connector, I encounter another problem:
It seems that "sets" are not recognised??
For exemple :
In this calculated field I use a set called « Dsl_Indispo_One_Day »
SUM(IIF(CONTAINS([Infra],'o1'),IIF([Dsl_Indispo_One_Day], 1, 0),0)) / SUM(IIF(CONTAINS([Infra],'o1'),1,0))
With the new connector, you can see that it has been replaced by [test] (Why ?) and it is writen that le calculation contains errors.
If I change in the [test] in _%NbIndispoDsl to use a condition instead of the « set », namely :
Instead of
The error disappears.
But, it doesn’t work with an other field.
If I do the same, it leads to an invalid calculation
and my dashboards are not displayed...
Thanks for your help.
Fred
The text was updated successfully, but these errors were encountered: