Re: [I] Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse [superset]
rusackas commented on issue #23384: URL: https://github.com/apache/superset/issues/23384#issuecomment-2218728367 It seems [this has been fixed on the CH side](https://github.com/apache/superset/pull/26735#issuecomment-2218461980) and this is no longer an issue. Closing, but happy to reopen if it's still an issue. -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse [superset]
rusackas closed issue #23384: Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse URL: https://github.com/apache/superset/issues/23384 -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse [superset]
Rydberg95 commented on issue #23384: URL: https://github.com/apache/superset/issues/23384#issuecomment-2056961849 > Can be fixed on ClickHouse side, with override default value for property **prefer_column_name_to_alias** > > via user setting for default profile > > ``` > > > > 1 > > > ... > ``` Thanks, seems to work great! As an alternative, if someone else wants to add the setting via [SQL-driven workflow](https://clickhouse.com/docs/en/operations/access-rights#access-control), the below command [sets up a new settings profile](https://clickhouse.com/docs/en/sql-reference/statements/create/settings-profile#create-settings-profile-statement) and assigns it to a user: `CREATE SETTINGS PROFILE superset SETTINGS prefer_column_name_to_alias = 1 TO *your_clickhouse_username*` -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse [superset]
NikoJ commented on issue #23384: URL: https://github.com/apache/superset/issues/23384#issuecomment-2056479582 @rusackas Thanks! When I have free time, I will check it and then close this issue as solved if everything is ok. -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse [superset]
rusackas commented on issue #23384: URL: https://github.com/apache/superset/issues/23384#issuecomment-2047699347 Thanks @kovitals - if anyone else on this thread finds this to be a sufficient answer (or even a sufficient workaround), this would be a great documentation update on the [Clickhouse docs page](https://superset.apache.org/docs/databases/clickhouse/). A PR from anyone would be helpful on that point to close this out. -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse [superset]
kovitals commented on issue #23384: URL: https://github.com/apache/superset/issues/23384#issuecomment-2047447780 Can be fixed on ClickHouse side, with user setting for default profile ``` **1** ... ``` -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
Re: [I] Error when using "TIME COLUMN" along with "X-AXIS" for same value for Clickhouse [superset]
chriscomeau79 commented on issue #23384: URL: https://github.com/apache/superset/issues/23384#issuecomment-1777985873 Still present in 3.0.1. The workaround above with setting a custom expression and alias works. Similar situation where we're trying to use a DateTime64 column as X axis and it's grouping by day, with inconsistent use of aliases in the generated query. -- 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-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org - To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org