[GitHub] [incubator-superset] saulfrank opened a new issue #7913: Druid most recent data using subquery filter for max(__time)

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

saulfrank opened a new issue #7913: Druid most recent data using subquery filter for max(__time)
URL: https://github.com/apache/incubator-superset/issues/7913
 
 
   ## [SIP] Proposal for most recent data in filter
   
   ### Motivation
   
   We are using Apache Druid to do stock and flow analysis. We tried to select the most recent date to show the most recent position. 
   
   I am not sure this is a bug or improvement or whether I am doing this incorrectly but we tried this: 
   
   select * from "druid"."table" 
   where file_date = (
   select max(file_date) as file_date from "druid"."table") or
   
   select * from "druid"."table" 
   where __time = (
   select max(__time) as file_date from "druid"."table")
   
   and got:
   Unknown exception (org.apache.druid.java.util.common.ISE): Cannot build plan for query
   
   ### Proposed Change
   
   It would be great to have a filter for aggregate functions. I tried using customer sql but that didn't work with Apache Druid. It does work with Postgresql. 
   

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