dosubot[bot] commented on issue #33076:
URL: https://github.com/apache/superset/issues/33076#issuecomment-2791862205
<!-- Answer -->
In the MySQL engine specification for Superset, the time grain expression
for the hour is defined as:
```python
TimeGrain.HOUR: "DATE_ADD(DATE({col}), INTERVAL HOUR({col}) HOUR)"
```
This expression is intended to adjust the datetime column to the start of
the hour by adding the hour component to the date part of the column
<sup>[[1]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/mysql.py)</sup>.
If this expression is not being applied properly in your Docker setup, it
could be due to a configuration issue or a bug in the master branch. You might
want to check if there are any recent changes or known issues related to time
grain expressions for MySQL in the master branch. Additionally, ensure that
your Superset instance is correctly configured to use this expression for MySQL.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great
Response](https://app.dosu.dev/response-feedback/313b7699-ce9e-4bcf-aad2-14bb871a5dae?feedback_type=great_response)
| [Irrelevant
Answer](https://app.dosu.dev/response-feedback/313b7699-ce9e-4bcf-aad2-14bb871a5dae?feedback_type=irrelevant_answer)
| [Incorrect
Sources](https://app.dosu.dev/response-feedback/313b7699-ce9e-4bcf-aad2-14bb871a5dae?feedback_type=incorrect_sources)
| [Too
Verbose](https://app.dosu.dev/response-feedback/313b7699-ce9e-4bcf-aad2-14bb871a5dae?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/313b7699-ce9e-4bcf-aad2-14bb871a5dae?feedback_type=hallucination)
| [Bug
Report](https://app.dosu.dev/response-feedback/313b7699-ce9e-4bcf-aad2-14bb871a5dae?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/313b7699-ce9e-4bcf-aad2-14bb871a5dae?feedback_type=other)</sup>
--
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]
