You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/06/19 05:47:18 UTC
[GitHub] [incubator-superset] som2014 opened a new issue #10107: Order By Clause Appended in Query
som2014 opened a new issue #10107:
URL: https://github.com/apache/incubator-superset/issues/10107
I have created a Line Chart using my Data Source Query looks like this :
```
SELECT date_trunc('minute', CAST("event_time" AS TIMESTAMP)) AS "__timestamp",
COUNT(*) AS "count"
FROM "table"
WHERE "event_time" >= from_iso8601_timestamp('2020-06-12T00:00:00.000000')
AND "event_time" < from_iso8601_timestamp('2020-06-19T00:00:00.000000')
GROUP BY date_trunc('minute', CAST("event_time" AS TIMESTAMP))
ORDER BY "count" DESC
LIMIT 1000;
```
Here Order BY is appended in my query by default ideally it should be order by `__timestamp`.
How to get rid of this ?
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10107: Order By Clause Appended in Query
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10107:
URL: https://github.com/apache/incubator-superset/issues/10107#issuecomment-646448000
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.59. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] stale[bot] closed issue #10107: Order By Clause Appended in Query
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #10107:
URL: https://github.com/apache/incubator-superset/issues/10107
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] zhaoyongjie commented on issue #10107: Order By Clause Appended in Query
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #10107:
URL: https://github.com/apache/incubator-superset/issues/10107#issuecomment-647327286
`Order By` clause can not be modified in the current Superset LineChart query object. However it has been sorted by timestamp in the visualization.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] stale[bot] commented on issue #10107: Order By Clause Appended in Query
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10107:
URL: https://github.com/apache/incubator-superset/issues/10107#issuecomment-703188966
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the 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.
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
[GitHub] [incubator-superset] som2014 commented on issue #10107: Order By Clause Appended in Query
Posted by GitBox <gi...@apache.org>.
som2014 commented on issue #10107:
URL: https://github.com/apache/incubator-superset/issues/10107#issuecomment-665711396
@zhaoyongjie why it's designed like this ? It's expected or bug ?
----------------------------------------------------------------
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.
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