[GitHub] keeyong opened a new issue #5489: SUM doesn't work somehow in Redshift table

[GitBox <gi...@apache.org>]

keeyong opened a new issue #5489: SUM doesn't work somehow in Redshift table
URL: https://github.com/apache/incubator-superset/issues/5489
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if 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
   
   ### Superset version
   0.26.3
   
   ### Expected results
   I was expecting to see daily revenue trending graph from a *Redshift* table and here is the SQL query:
   
       SELECT
           name AS name,
           DATE_TRUNC('month', created_date) AT TIME ZONE 'UTC' AS __timestamp,
           SUM(cost) AS "SUM(cost)"
       FROM xxxx.yyyyyy
       WHERE created_date >= '2016-07-26 00:00:00'
           AND created_date <= '2018-07-26 03:32:14'
       GROUP BY name,
            DATE_TRUNC('month', created_date) AT TIME ZONE 'UTC'
       ORDER BY "SUM(cost)" DESC
       LIMIT 50000;
   
   ### Actual results
   <img width="729" alt="sum error" src="https://user-images.githubusercontent.com/1441533/43240165-fd7afd5c-9049-11e8-83b9-b9431ec54b56.png">
   
   I tried a few different tables but got exactly same result. I used the following connection string:
   postgresql+psycopg2://account:XXXXXXXXXX@redshift-host-name:5439/database
   
   ### Steps to reproduce
   Hopefully the above screen and script are self-explanatory. 
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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


With regards,
Apache Git Services

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