You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "sowo (via GitHub)" <gi...@apache.org> on 2023/02/01 17:26:23 UTC

[GitHub] [superset] sowo commented on issue #21755: x-aixs alias name same as original field name

sowo commented on issue #21755:
URL: https://github.com/apache/superset/issues/21755#issuecomment-1412441498

   Sorry, can't screen record. So here's what you get when using a dataset derived from Elasticsearch:
   ![image](https://user-images.githubusercontent.com/2765941/216116694-08c67a4b-a431-4789-9706-9af09d536191.png)
   
   And here's the underlying query that produces the issue:
   
   ```
   SELECT HISTOGRAM("DATE", INTERVAL 1 DAY) AS "DATE",
          count(*) AS count
   FROM
     (select "DATE",
             "ITEM"
      from "table") AS virtual_table
   GROUP BY "DATE"
   ORDER BY count DESC
   LIMIT 10000;
   ```
   
   I think that Elastic gets confused by the column name "DATE" being used in the inner and outer queries.


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