You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "bb33chen (via GitHub)" <gi...@apache.org> on 2025/09/26 07:44:28 UTC

[D] Why doesn't Doris support quarter aggregation? [superset]

GitHub user bb33chen created a discussion: Why doesn't Doris support quarter aggregation?

<img width="1911" height="919" alt="WeChatWorkScreenshot_89b40fc9-0ba8-4d75-be55-42477415b0fb" src="https://github.com/user-attachments/assets/f7249d04-a758-4eca-890a-9ba99d574e4e" />
<img width="1899" height="501" alt="WeChatWorkScreenshot_5b2e061e-fa11-4db5-a3ae-4479a305a97b" src="https://github.com/user-attachments/assets/bb287016-7a85-4176-93b9-49e60f032e5a" />


GitHub link: https://github.com/apache/superset/discussions/35304

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "bb33chen (via GitHub)" <gi...@apache.org>.
GitHub user bb33chen added a comment to the discussion: Why doesn't Doris support quarter aggregation?

@dosubot
Hi dosu, can you help to resolve this problem?

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519718

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] added a comment to the discussion: Why doesn't Doris support quarter aggregation?

<!-- Greeting -->
Hi @bb33chen! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team.

<!-- Answer -->
Doris (and MySQL) don't support 'QUARTER' as a valid interval unit in SQL, which is why quarter aggregation fails with a syntax error in Superset. Superset's Doris engine spec inherits MySQL's unsupported quarter syntax, so there's no working quarter time grain by default.

To work around this, you can remove the time grain setting in Superset and use a custom SQL expression in your chart's x-axis to manually extract the year and quarter. For example, you could use something like `CONCAT(YEAR(Shipping_Date), '-Q', QUARTER(Shipping_Date))` if Doris supports the `QUARTER()` function for extracting the quarter number, or build a calculated column in your dataset that represents year and quarter as a string (like `'2024-Q1'`) and group by that column instead. This approach is commonly used for databases that lack native quarter support in their time grain functions [example workaround](https://github.com/apache/superset/issues/26383#issuecomment-1883395006).

If you want a more permanent fix, you could customize the Doris engine spec in Superset to add a working quarter time grain expression, similar to how other databases (like Impala) use `DATE_TRUNC('quarter', {col})` [see reference](https://github.com/apache/superset/issues/33033), but this would require code changes.

Make sure your datetime column is of a recognized datetime type in Doris, as Superset's time grain controls only work with temporal columns [details](https://github.com/apache/superset/discussions/33692).


<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*

---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=other)</sup>&nbsp;&nbsp;[![Chat with Dosu](https://dosu.dev/dosu-chat-badge.svg)](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)&
 nbsp;[![Join Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.dosu.dev/discord-bot)&nbsp;[![Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/35304)

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519748

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "bb33chen (via GitHub)" <gi...@apache.org>.
GitHub user bb33chen added a comment to the discussion: Why doesn't Doris support quarter aggregation?

@villebro 
Could you help point out the specific code location for the modification?



GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519935

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "bb33chen (via GitHub)" <gi...@apache.org>.
GitHub user bb33chen added a comment to the discussion: Why doesn't Doris support quarter aggregation?

> Hi @bb33chen! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team.
> 
> Doris (and MySQL) don't support 'QUARTER' as a valid interval unit in SQL, which is why quarter aggregation fails with a syntax error in Superset. Superset's Doris engine spec inherits MySQL's unsupported quarter syntax, so there's no working quarter time grain by default.
> 
> To work around this, you can remove the time grain setting in Superset and use a custom SQL expression in your chart's x-axis to manually extract the year and quarter. For example, you could use something like `CONCAT(YEAR(Shipping_Date), '-Q', QUARTER(Shipping_Date))` if Doris supports the `QUARTER()` function for extracting the quarter number, or build a calculated column in your dataset that represents year and quarter as a string (like `'2024-Q1'`) and group by that column instead. This approach is commonly used for databases that lack native quarter support in their time grain functions [example workaround](https://github.com/apache/superset/issues/26383#issuecomment-1883395006).
> 
> If you want a more permanent fix, you could customize the Doris engine spec in Superset to add a working quarter time grain expression, similar to how other databases (like Impala) use `DATE_TRUNC('quarter', {col})` [see reference](https://github.com/apache/superset/issues/33033), but this would require code changes.
> 
> Make sure your datetime column is of a recognized datetime type in Doris, as Superset's time grain controls only work with temporal columns [details](https://github.com/apache/superset/discussions/33692).
> 
> _To reply, just mention [@dosu](https://go.dosu.dev/dosubot)._
> 
> How did I do? [Good](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/27479836-6728-48f6-a3ac-f73ef204725c?feedback_type=other)  [![Chat with Dosu](https://camo.githubusercontent.com/d9ffebb979729c9ef0fc4e3090dbae5b17cabbfec8afe378ada6b81913d6ad8a/68747470733a2f2f646f73752e6465762f646
 f73752d636861742d62616467652e737667)](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [![Join Discord](https://camo.githubusercontent.com/d562c2df5e4567ea41d37f1d91a4da0839d8341037045b103b2da268998de17f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6a6f696e2d3538363546323f6c6f676f3d646973636f7264266c6f676f436f6c6f723d7768697465266c6162656c3d)](https://go.dosu.dev/discord-bot) [![Share on X](https://camo.githubusercontent.com/4649f705e2396d6f328dbc8e800a0509c9c17b3b20253b36706c393df124b93d/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f582d73686172652d626c61636b)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/35304)

Could you help point out the specific code location for the modification?

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519895

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "bb33chen (via GitHub)" <gi...@apache.org>.
GitHub user bb33chen added a comment to the discussion: Why doesn't Doris support quarter aggregation?

Could you help point out the specific code location for the modification?

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519890

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "bb33chen (via GitHub)" <gi...@apache.org>.
GitHub user bb33chen edited a comment on the discussion: Why doesn't Doris support quarter aggregation?

 @villebro @claude @mistercrunch @betodealmeida 
Hi all, can you help to resolve this problem?

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519718

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] added a comment to the discussion: Why doesn't Doris support quarter aggregation?

<!-- Answer -->
The code you need to modify is in superset/db_engine_specs/doris.py, inside the DorisEngineSpec class. To fix quarter aggregation, override the _time_grain_expressions dictionary in DorisEngineSpec and provide a Doris-compatible SQL expression for TimeGrain.QUARTER. For example, if Doris supports QUARTER() and YEAR(), you could use something like:

```python
from superset.db_engine_specs.base import TimeGrain

_time_grain_expressions = {
    **MySQLEngineSpec._time_grain_expressions,
    TimeGrain.QUARTER: "CONCAT(YEAR({col}), '-Q', QUARTER({col}))",
}
```

This approach is similar to how other engines (like Impala) define custom time grains in their engine spec files ([reference](https://github.com/apache/superset/issues/33033)). The key is to override the inherited MySQL quarter logic, which Doris does not support, with an expression that works for Doris.


<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*

---
<sup>How did I do? [Good](https://app.dosu.dev/response-feedback/1aa96df4-9dce-4cd6-869d-6e50d15e885f?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/1aa96df4-9dce-4cd6-869d-6e50d15e885f?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/1aa96df4-9dce-4cd6-869d-6e50d15e885f?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/1aa96df4-9dce-4cd6-869d-6e50d15e885f?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/1aa96df4-9dce-4cd6-869d-6e50d15e885f?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/1aa96df4-9dce-4cd6-869d-6e50d15e885f?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/1aa96df4-9dce-4cd6-869d-6e50d15e885f?feedback_type=other)</sup>&nbsp;&nbsp;[![Chat with Dosu](https://dosu.dev/dosu-chat-badge.svg)](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)&
 nbsp;[![Join Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.dosu.dev/discord-bot)&nbsp;[![Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/35304)

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519937

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Why doesn't Doris support quarter aggregation?

<!-- Greeting -->
Hi @bb33chen! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team.

<!-- Answer -->
Doris (and MySQL) don't support 'QUARTER' as a valid interval unit in SQL, which is why quarter aggregation fails with a syntax error in Superset. Superset's Doris engine spec inherits MySQL's unsupported quarter syntax, so there's no working quarter time grain by default.

To work around this, you can remove the time grain setting in Superset and use a custom SQL expression in your chart's x-axis to manually extract the year and quarter. For example, you could use something like `CONCAT(YEAR(Shipping_Date), '-Q', QUARTER(Shipping_Date))` if Doris supports the `QUARTER()` function for extracting the quarter number, or build a calculated column in your dataset that represents year and quarter as a string (like `'2024-Q1'`) and group by that column instead. This approach is commonly used for databases that lack native quarter support in their time grain functions [example workaround](https://github.com/apache/superset/issues/26383#issuecomment-1883395006).

If you want a more permanent fix, you could customize the Doris engine spec in Superset to add a working quarter time grain expression, similar to how other databases (like Impala) use `DATE_TRUNC('quarter', {col})` [see reference](https://github.com/apache/superset/issues/33033), but this would require code changes.

Make sure your datetime column is of a recognized datetime type in Doris, as Superset's time grain controls only work with temporal columns [details](https://github.com/apache/superset/discussions/33692).


<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*

---

Share context across your team and agents. Try [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-tagline&utm_term=apache%2Fsuperset).

[![Leave Feedback](https://img.shields.io/badge/Leave%20Feedback-555555?style=flat)](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-feedback&utm_term=apache%2Fsuperset&message_id=27479836-6728-48f6-a3ac-f73ef204725c) [![Learn about superset with Dosu](https://img.shields.io/badge/Learn%20about%20superset%20with%20Dosu-2f7b3f?style=flat&logo=data%3Aimage%2Fsvg%2Bxml%3Bbase64%2CPHN2ZyB3aWR0aD0iODYiIGhlaWdodD0iODkiIHZpZXdCb3g9IjAgMCA4NiA4OSIgZmlsbD0ibm9uZSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48cGF0aCBkPSJNNS4yOTIzNiAxMi43OTI4TDE3Ljc1OTMgNi42ODE4OFY3Mi41NjY3TDUuMjkyMzYgODQuMDYxOFYxMi43OTI4WiIgZmlsbD0iI0I0QkI5MSIvPjxwYXRoIGQ9Ik0xOC4yNTc1IDczLjExOTZMNTkuMTMyOSA3Mi43NDhMNTEuNzAxMSA4Mi40MDk1TDI5LjAzMzggODYuMjkxTDYuMjM5NjIgODUuMTU1NEwxOC4yNTc1IDczLjExOTZaIiBmaWxsPSIjNzc4NTYxIi8%2BPHBhdGggZD0iTTE3LjQ5MTYgMy43MzYzM0wzLjU4NTU3IDEyLjcwOTlWODMuNTc5MkMzLjU4NTU3IDg0Ljc1NDIgNC4
 5ODU2MyA4NS4zNjUyIDUuODQ3MDUgODQuNTY2TDE5LjYyOTYgNzEuNzgwMSIgc3Ryb2tlPSJibGFjayIgc3Ryb2tlLXdpZHRoPSI2LjQyODQ0IiBzdHJva2UtbGluZWNhcD0icm91bmQiLz48bWFzayBpZD0iZG9zdS1kLWN1dG91dCIgZmlsbD0id2hpdGUiPjxwYXRoIGZpbGwtcnVsZT0iZXZlbm9kZCIgY2xpcC1ydWxlPSJldmVub2RkIiBkPSJNNDAuNzA0IDAuNTE4MDY2SDE3LjA0MzlWNzYuMjIyMUg0MC43MDRINDIuNTgwNUg0Ny44MDEzQzY4LjcwNjQgNzYuMjIyMSA4NS42NTMzIDU5LjI3NTIgODUuNjUzMyAzOC4zNzAxQzg1LjY1MzMgMTcuNDY1IDY4LjcwNjMgMC41MTgwNjYgNDcuODAxMyAwLjUxODA2Nkg0Mi41ODA1SDQwLjcwNFoiLz48L21hc2s%2BPHBhdGggZmlsbC1ydWxlPSJldmVub2RkIiBjbGlwLXJ1bGU9ImV2ZW5vZGQiIGQ9Ik00MC43MDQgMC41MTgwNjZIMTcuMDQzOVY3Ni4yMjIxSDQwLjcwNEg0Mi41ODA1SDQ3LjgwMTNDNjguNzA2NCA3Ni4yMjIxIDg1LjY1MzMgNTkuMjc1MiA4NS42NTMzIDM4LjM3MDFDODUuNjUzMyAxNy40NjUgNjguNzA2MyAwLjUxODA2NiA0Ny44MDEzIDAuNTE4MDY2SDQyLjU4MDVINDAuNzA0WiIgZmlsbD0iI0YzRjZGMSIvPjxwYXRoIGQ9Ik0xNy4wNDM5IDAuNTE4MDY2Vi02LjU3OTE5SDkuOTQ2NjlWMC41MTgwNjZIMTcuMDQzOVpNMTcuMDQzOSA3Ni4yMjIxSDkuOTQ2NjlWODMuMzE5NEgxNy4wNDM5Vjc2LjIyMjFaTTE3LjA0MzkgNy42MTUzMkg0MC43MDRWLTYuNT
 c5MTlIMTcuMDQzOVY3LjYxNTMyWk0yNC4xNDEyIDc2LjIyMjFWMC41MTgwNjZIOS45NDY2OVY3Ni4yMjIxSDI0LjE0MTJaTTQwLjcwNCA2OS4xMjQ5SDE3LjA0MzlWODMuMzE5NEg0MC43MDRWNjkuMTI0OVpNNDIuNTgwNSA2OS4xMjQ5SDQwLjcwNFY4My4zMTk0SDQyLjU4MDVWNjkuMTI0OVpNNDcuODAxMyA2OS4xMjQ5SDQyLjU4MDVWODMuMzE5NEg0Ny44MDEzVjY5LjEyNDlaTTc4LjU1NiAzOC4zNzAxQzc4LjU1NiA1NS4zNTU1IDY0Ljc4NjcgNjkuMTI0OSA0Ny44MDEzIDY5LjEyNDlWODMuMzE5NEM3Mi42MjYxIDgzLjMxOTQgOTIuNzUwNSA2My4xOTQ5IDkyLjc1MDUgMzguMzcwMUg3OC41NTZaTTQ3LjgwMTMgNy42MTUzMkM2NC43ODY2IDcuNjE1MzIgNzguNTU2IDIxLjM4NDcgNzguNTU2IDM4LjM3MDFIOTIuNzUwNUM5Mi43NTA1IDEzLjU0NTMgNzIuNjI2IC02LjU3OTE5IDQ3LjgwMTMgLTYuNTc5MTlWNy42MTUzMlpNNDIuNTgwNSA3LjYxNTMySDQ3LjgwMTNWLTYuNTc5MTlINDIuNTgwNVY3LjYxNTMyWk00MC43MDQgNy42MTUzMkg0Mi41ODA1Vi02LjU3OTE5SDQwLjcwNFY3LjYxNTMyWiIgZmlsbD0iYmxhY2siIG1hc2s9InVybCgjZG9zdS1kLWN1dG91dCkiLz48cGF0aCBkPSJNNjguOTIxNSAzNi4wMTM1QzY4LjkyMTUgMzYuMDEzNSA2NS43MzY5IDQ5LjQ3MzggNTEuNDIzMSA0OS40NzM4QzM3LjEwOTMgNDkuNDczOCAzMi41Nzg3IDM3LjM1OTYgMzIuNTc4NyAzNi4wMTM1IiBzdHJva2U9ImJsYWNrIiB
 zdHJva2Utd2lkdGg9IjcuNjkxNjEiIHN0cm9rZS1saW5lY2FwPSJyb3VuZCIgc3Ryb2tlLWxpbmVqb2luPSJyb3VuZCIvPjxwYXRoIGQ9Ik0wLjM0ODYzMyA4NS40OTQ2QzAuMzQ4NjMzIDg1LjQ5NDYgMjkuNDg1NiA4NS44MzA5IDM0LjgwOSA4NS42OThDNDQuODMzNyA4NS40NDc3IDUxLjI4NzIgODQuNDAyIDU3LjUyNjkgNzguOTcyNEM2Mi44MTI5IDc0LjM3MjcgNzUuMTM0MiA1OS42ODM2IDc1LjEzNDIgNTkuNjgzNiIgc3Ryb2tlPSJibGFjayIgc3Ryb2tlLXdpZHRoPSI2LjE2NDgyIi8%2BPC9zdmc%2B)](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-learn-repo&utm_term=apache%2Fsuperset) [![Add Dosu to your team](https://img.shields.io/badge/Add%20Dosu%20to%20your%20team-1f6feb?style=flat)](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=knowledge-infrastructure-add-team&utm_term=apache%2Fsuperset)

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519748

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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


Re: [D] Why doesn't Doris support quarter aggregation? [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
GitHub user dosubot[bot] edited a comment on the discussion: Why doesn't Doris support quarter aggregation?

<!-- Answer -->
The code you need to modify is in superset/db_engine_specs/doris.py, inside the DorisEngineSpec class. To fix quarter aggregation, override the _time_grain_expressions dictionary in DorisEngineSpec and provide a Doris-compatible SQL expression for TimeGrain.QUARTER. For example, if Doris supports QUARTER() and YEAR(), you could use something like:

```python
from superset.db_engine_specs.base import TimeGrain

_time_grain_expressions = {
    **MySQLEngineSpec._time_grain_expressions,
    TimeGrain.QUARTER: "CONCAT(YEAR({col}), '-Q', QUARTER({col}))",
}
```

This approach is similar to how other engines (like Impala) define custom time grains in their engine spec files ([reference](https://github.com/apache/superset/issues/33033)). The key is to override the inherited MySQL quarter logic, which Doris does not support, with an expression that works for Doris.


<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*

---

Docs are dead. Just use [Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-tagline&utm_term=apache%2Fsuperset).

[![Leave Feedback](https://img.shields.io/badge/Leave%20Feedback-555555?style=flat)](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=1aa96df4-9dce-4cd6-869d-6e50d15e885f) [![Ask Dosu about superset](https://img.shields.io/badge/Ask%20Dosu%20about%20superset-2f7b3f?style=flat&logo=data%3Aimage%2Fsvg%2Bxml%3Bbase64%2CPHN2ZyB3aWR0aD0iODYiIGhlaWdodD0iODkiIHZpZXdCb3g9IjAgMCA4NiA4OSIgZmlsbD0ibm9uZSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj48cGF0aCBkPSJNNS4yOTIzNiAxMi43OTI4TDE3Ljc1OTMgNi42ODE4OFY3Mi41NjY3TDUuMjkyMzYgODQuMDYxOFYxMi43OTI4WiIgZmlsbD0iI0I0QkI5MSIvPjxwYXRoIGQ9Ik0xOC4yNTc1IDczLjExOTZMNTkuMTMyOSA3Mi43NDhMNTEuNzAxMSA4Mi40MDk1TDI5LjAzMzggODYuMjkxTDYuMjM5NjIgODUuMTU1NEwxOC4yNTc1IDczLjExOTZaIiBmaWxsPSIjNzc4NTYxIi8%2BPHBhdGggZD0iTTE3LjQ5MTYgMy43MzYzM0wzLjU4NTU3IDEyLjcwOTlWODMuNTc5MkMzLjU4NTU3IDg0Ljc1NDIgNC45ODU2MyA4NS4zNjUyIDUuODQ3MDUg
 ODQuNTY2TDE5LjYyOTYgNzEuNzgwMSIgc3Ryb2tlPSJibGFjayIgc3Ryb2tlLXdpZHRoPSI2LjQyODQ0IiBzdHJva2UtbGluZWNhcD0icm91bmQiLz48bWFzayBpZD0iZG9zdS1kLWN1dG91dCIgZmlsbD0id2hpdGUiPjxwYXRoIGZpbGwtcnVsZT0iZXZlbm9kZCIgY2xpcC1ydWxlPSJldmVub2RkIiBkPSJNNDAuNzA0IDAuNTE4MDY2SDE3LjA0MzlWNzYuMjIyMUg0MC43MDRINDIuNTgwNUg0Ny44MDEzQzY4LjcwNjQgNzYuMjIyMSA4NS42NTMzIDU5LjI3NTIgODUuNjUzMyAzOC4zNzAxQzg1LjY1MzMgMTcuNDY1IDY4LjcwNjMgMC41MTgwNjYgNDcuODAxMyAwLjUxODA2Nkg0Mi41ODA1SDQwLjcwNFoiLz48L21hc2s%2BPHBhdGggZmlsbC1ydWxlPSJldmVub2RkIiBjbGlwLXJ1bGU9ImV2ZW5vZGQiIGQ9Ik00MC43MDQgMC41MTgwNjZIMTcuMDQzOVY3Ni4yMjIxSDQwLjcwNEg0Mi41ODA1SDQ3LjgwMTNDNjguNzA2NCA3Ni4yMjIxIDg1LjY1MzMgNTkuMjc1MiA4NS42NTMzIDM4LjM3MDFDODUuNjUzMyAxNy40NjUgNjguNzA2MyAwLjUxODA2NiA0Ny44MDEzIDAuNTE4MDY2SDQyLjU4MDVINDAuNzA0WiIgZmlsbD0iI0YzRjZGMSIvPjxwYXRoIGQ9Ik0xNy4wNDM5IDAuNTE4MDY2Vi02LjU3OTE5SDkuOTQ2NjlWMC41MTgwNjZIMTcuMDQzOVpNMTcuMDQzOSA3Ni4yMjIxSDkuOTQ2NjlWODMuMzE5NEgxNy4wNDM5Vjc2LjIyMjFaTTE3LjA0MzkgNy42MTUzMkg0MC43MDRWLTYuNTc5MTlIMTcuMDQzOVY3LjYxNTMyWk0
 yNC4xNDEyIDc2LjIyMjFWMC41MTgwNjZIOS45NDY2OVY3Ni4yMjIxSDI0LjE0MTJaTTQwLjcwNCA2OS4xMjQ5SDE3LjA0MzlWODMuMzE5NEg0MC43MDRWNjkuMTI0OVpNNDIuNTgwNSA2OS4xMjQ5SDQwLjcwNFY4My4zMTk0SDQyLjU4MDVWNjkuMTI0OVpNNDcuODAxMyA2OS4xMjQ5SDQyLjU4MDVWODMuMzE5NEg0Ny44MDEzVjY5LjEyNDlaTTc4LjU1NiAzOC4zNzAxQzc4LjU1NiA1NS4zNTU1IDY0Ljc4NjcgNjkuMTI0OSA0Ny44MDEzIDY5LjEyNDlWODMuMzE5NEM3Mi42MjYxIDgzLjMxOTQgOTIuNzUwNSA2My4xOTQ5IDkyLjc1MDUgMzguMzcwMUg3OC41NTZaTTQ3LjgwMTMgNy42MTUzMkM2NC43ODY2IDcuNjE1MzIgNzguNTU2IDIxLjM4NDcgNzguNTU2IDM4LjM3MDFIOTIuNzUwNUM5Mi43NTA1IDEzLjU0NTMgNzIuNjI2IC02LjU3OTE5IDQ3LjgwMTMgLTYuNTc5MTlWNy42MTUzMlpNNDIuNTgwNSA3LjYxNTMySDQ3LjgwMTNWLTYuNTc5MTlINDIuNTgwNVY3LjYxNTMyWk00MC43MDQgNy42MTUzMkg0Mi41ODA1Vi02LjU3OTE5SDQwLjcwNFY3LjYxNTMyWiIgZmlsbD0iYmxhY2siIG1hc2s9InVybCgjZG9zdS1kLWN1dG91dCkiLz48cGF0aCBkPSJNNjguOTIxNSAzNi4wMTM1QzY4LjkyMTUgMzYuMDEzNSA2NS43MzY5IDQ5LjQ3MzggNTEuNDIzMSA0OS40NzM4QzM3LjEwOTMgNDkuNDczOCAzMi41Nzg3IDM3LjM1OTYgMzIuNTc4NyAzNi4wMTM1IiBzdHJva2U9ImJsYWNrIiBzdHJva2Utd2lkdGg9IjcuNjkxNjEi
 IHN0cm9rZS1saW5lY2FwPSJyb3VuZCIgc3Ryb2tlLWxpbmVqb2luPSJyb3VuZCIvPjxwYXRoIGQ9Ik0wLjM0ODYzMyA4NS40OTQ2QzAuMzQ4NjMzIDg1LjQ5NDYgMjkuNDg1NiA4NS44MzA5IDM0LjgwOSA4NS42OThDNDQuODMzNyA4NS40NDc3IDUxLjI4NzIgODQuNDAyIDU3LjUyNjkgNzguOTcyNEM2Mi44MTI5IDc0LjM3MjcgNzUuMTM0MiA1OS42ODM2IDc1LjEzNDIgNTkuNjgzNiIgc3Ryb2tlPSJibGFjayIgc3Ryb2tlLXdpZHRoPSI2LjE2NDgyIi8%2BPC9zdmc%2B)](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-repo&utm_term=apache%2Fsuperset) [![Share Dosu with your team](https://img.shields.io/badge/Share%20Dosu%20with%20your%20team-1f6feb?style=flat)](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-share-team&utm_term=apache%2Fsuperset)

GitHub link: https://github.com/apache/superset/discussions/35304#discussioncomment-14519937

----
This is an automatically sent email for notifications@superset.apache.org.
To unsubscribe, please send an email to: notifications-unsubscribe@superset.apache.org


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