vestrik opened a new issue, #33076:
URL: https://github.com/apache/superset/issues/33076

   ### Bug description
   
   Sql query for line chart with time grain is wrong in superset from master 
version.
   1. Install superset with docker from master branch
   2. Create line chart with time column on X-axis
   3. Choose hour time grain
   Data not groupped properly by hours, caused by SQL query
   
   ### Screenshots/recordings
   
   ### Master branch docker with latest commit [6b7394e]
   Samples:
   
![Image](https://github.com/user-attachments/assets/31236591-8b6f-420f-aaa5-22ca0e25d875)
   Chart and result data:
   
   
![Image](https://github.com/user-attachments/assets/9a009571-e708-4a42-976c-5b5edf6286b2)
   SQL:
   
   
![Image](https://github.com/user-attachments/assets/f7bd854a-0652-4b58-8ef3-6877c2725a1e)
   
   ### 4.1.1 from pip, where everything works as expected:
   Samples for chart:
   
![Image](https://github.com/user-attachments/assets/6510e5bf-e5a4-4f5c-a5f7-ceca4a3fd9ce)
   Chart and result data:
   
![Image](https://github.com/user-attachments/assets/585ee906-e27e-4a7a-9ad4-0cd940fdaedf)
   SQL:
   
   
![Image](https://github.com/user-attachments/assets/0cb03d0e-73a0-4300-8bf7-920ff43e1895)
   
   
   ### Superset version
   
   master / latest-dev
   
   ### Python version
   
   3.9
   
   ### Node version
   
   16
   
   ### Browser
   
   Chrome
   
   ### Additional context
   
   _No response_
   
   ### Checklist
   
   - [ ] I have searched Superset docs and Slack and didn't find a solution to 
my problem.
   - [ ] I have searched the GitHub issue tracker and didn't find a similar bug 
report.
   - [ ] I have checked Superset's logs for errors and if I found a relevant 
Python stacktrace, I included it here as text in the "additional context" 
section.


-- 
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]

Reply via email to