[GitHub] [superset] romamur commented on issue #18834: Clickhouse SQL syntax error in group by time_grain_expressions

[GitBox <gi...@apache.org>]

romamur commented on issue #18834:
URL: https://github.com/apache/superset/issues/18834#issuecomment-1048498956


   > Thanks for reporting - this appears to be a bug in how the ClickHouse dialect renders the `ColumnElement` (it should know how to render it, as the object has both the expression and alias available). Which SQLAlchemy connector + version are you using?
   
   Thanks for reply. My drivers versions:
   ```
   clickhouse-sqlalchemy v0.1.6
   clickhouse-driver v0.2.3
   ```
   I'm connected to db via http interface. My connection string was:
   `clickhouse://secretgithubuser:secretgithubpass@127.0.0.1:8123/secretgithubdb`
   
   BTW this is another bug but I will write about it too. I'm change connection to clickhouse+native and some bugs disappeared. For example "superset filter box chart" show me empty results in dropdown filter (when connection was clickhouse http). DDL of column was Int8 Not Null and contained only values '1' or '0'. When i change connection to clickhouse+native my dropdown filter was showing me the correct values to select '1' or '0'


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org