You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "dannymk (via GitHub)" <gi...@apache.org> on 2023/10/30 18:39:16 UTC
[I] Time range changed to TO_DATE('2023-10-30', 'YYYY-MM-DD') [superset]
dannymk opened a new issue, #25796:
URL: https://github.com/apache/superset/issues/25796
Adding a time range filter and selecting a proper time range such as midnight until NOW (2023-10-30 15:00:00) makes the query:
SELECT store AS store,
count(issue_hour) AS "COUNT(issue_hour)"
FROM
(select left(d.network_hostname, 4) store,
s.pass_date issue_date,
extract(HOUR
FROM s.pass_date) issue_hour
from passes s
join system d on s.system_id = d.system_id) AS virtual_table
WHERE issue_date >= TO_DATE('2023-10-30', 'YYYY-MM-DD')
AND issue_date < TO_DATE('2023-10-30', 'YYYY-MM-DD')
GROUP BY store
ORDER BY "COUNT(issue_hour)" DESC
LIMIT 1000;
#### How to reproduce the bug
1. Go to the dashboard
2. Click on 'view query' for the specified chart
3. See generated sql
### Expected results
The query should show TO_TIMESTAMP instead of TO_DATE when using time range
### Actual results
WHERE issue_date >= TO_DATE('2023-10-30', 'YYYY-MM-DD')
AND issue_date < TO_DATE('2023-10-30', 'YYYY-MM-DD')
#### Screenshots
If applicable, add screenshots to help explain your problem.
### Environment
(please complete the following information):
- browser type and version: ALL
- superset version: `3.0.0`
- python version: `python --version`
- node.js version: `node -v`
- any feature flags active:
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
--
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-unsubscribe@superset.apache.org.apache.org
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
Re: [I] Time range changed to TO_DATE('2023-10-30', 'YYYY-MM-DD') [superset]
Posted by "dannymk (via GitHub)" <gi...@apache.org>.
dannymk closed issue #25796: Time range changed to TO_DATE('2023-10-30', 'YYYY-MM-DD')
URL: https://github.com/apache/superset/issues/25796
--
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-unsubscribe@superset.apache.org
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
Re: [I] Time range changed to TO_DATE('2023-10-30', 'YYYY-MM-DD') [superset]
Posted by "dannymk (via GitHub)" <gi...@apache.org>.
dannymk commented on issue #25796:
URL: https://github.com/apache/superset/issues/25796#issuecomment-1785831554
already reporting in #25637
--
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-unsubscribe@superset.apache.org
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