[GitHub] [superset] Dr9vik opened a new issue #17036: time series {name} chart and command join

[GitBox]

Dr9vik opened a new issue #17036:
URL: https://github.com/apache/superset/issues/17036


   this is standart time series bar chart:
   
![vivaldi_0MqYMCNKc7](https://user-images.githubusercontent.com/36520921/136579194-d97d2bbd-a971-44d9-bc02-fc982276b61b.png)
   
   query:
   ```
   SELECT DATE(order_date, -strftime('%d', order_date) || ' days', '+1 day') AS 
__timestamp,
          deal_size AS deal_size,
          sum(sales) AS "(Sales)"
   FROM "Vehicle Sales"
   JOIN
     (SELECT deal_size AS deal_size__,
             sum(sales) AS mme_inner__
      FROM "Vehicle Sales"
      WHERE order_date >= '2003-01-01 00:00:00.000000'
        AND order_date < '2005-06-01 00:00:00.000000'
      GROUP BY deal_size
      ORDER BY mme_inner__ DESC
      LIMIT 100
      OFFSET 0) AS anon_1 ON deal_size = deal_size__
   WHERE order_date >= '2003-01-01 00:00:00.000000'
     AND order_date < '2005-06-01 00:00:00.000000'
   GROUP BY deal_size,
            DATE(order_date, -strftime('%d', order_date) || ' days', '+1 day')
   ORDER BY "(Sales)" DESC
   LIMIT 50000
   OFFSET 0;
   ```
   
   request that should have been:
   ```
   SELECT DATE(order_date, -strftime('%d', order_date) || ' days', '+1 day') AS 
__timestamp,
          deal_size AS deal_size,
          sum(sales) AS "(Sales)"
   FROM "Vehicle Sales"
   WHERE order_date >= '2003-01-01 00:00:00.000000'
     AND order_date < '2005-06-01 00:00:00.000000'
   GROUP BY deal_size,
            DATE(order_date, -strftime('%d', order_date) || ' days', '+1 day')
   ORDER BY "(Sales)" DESC
   LIMIT 50000
   OFFSET 0;
   ```
   why does superset add this request?
   ```
   JOIN
     (SELECT deal_size AS deal_size__,
             sum(sales) AS mme_inner__
      FROM "Vehicle Sales"
      WHERE order_date >= '2003-01-01 00:00:00.000000'
        AND order_date < '2005-06-01 00:00:00.000000'
      GROUP BY deal_size
      ORDER BY mme_inner__ DESC
      LIMIT 100
      OFFSET 0) AS anon_1 ON deal_size = deal_size__
   
   ```
   This JOIN increases the data loading time
   Old superset works fine
   


-- 
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-unsubscr...@superset.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



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