fhyy commented on PR #29455:
URL: https://github.com/apache/superset/pull/29455#issuecomment-2440836668
> **Edit:**
>
> * [ ] Heatmap is not working
>
>
> ```sql
> SELECT
> NEARESTDATE(`Timestamp`, 'DAY') AS `Timestamp__`,
> `DB User Name` AS `DB User Name`,
> count(DISTINCT `Timestamp`) AS `COUNT_DISTINCT(Timestamp)`
> FROM `mongo`.`sonar_log`.`audit_log`
> GROUP BY
> NEARESTDATE(`Timestamp`, 'DAY'),
> `DB User Name`
> ORDER BY
> `Timestamp` ASC,
> `DB User Name` ASC
> LIMIT 10000;
> ```
Hi @joeyJsonar, can you clarify what you mean by "Heatmap is not working" in
this example?
The query does not seem to use any aliases that would break it.
`GROUP BY NEARESTDATE('Timestamp', 'DAY')` instead of `GROUP BY
'Timestamp__'` is a bit silly but should not be a problem, and it is not an
issue this PR intended to fix (nor cause).
Thanks!
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
