[GitHub] sakshi-23 opened a new issue #6711: Unable to run query with multiple subqueries

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

sakshi-23 opened a new issue #6711: Unable to run query with multiple subqueries 
URL: https://github.com/apache/incubator-druid/issues/6711
 
 
   I am trying to run a query that has multiple sub queries : 
   
   `select distinct(customer) from event_segment where country in (select val from hierarchy_segment where ancestor='Europe' and category='country') and product in (select val from hierarchy_segment where ancestor='12345'  and category='product')`
   
   
   but getting the error:
   `{u'errorClass': u'io.druid.java.util.common.ISE', u'host': None, u'errorMessage': u"Cannot build plan for query: select distinct(customer) from event_segment where country in (select val from hierarchy_segment where ancestor='Europe' and category='country') and product in (select val from hierarchy_segment where ancestor='12345'  and category='product')", u'error': u'Unknown exception'}`
   
   Is there any other way to run this semi-join query besides running them as multiple queries?
   
   How to reproduce ->
   Run any nested query like above on on v0.12.3

----------------------------------------------------------------
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: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org