sachidananda007 commented on issue #13091:
URL: https://github.com/apache/druid/issues/13091#issuecomment-1251040396

   i found this when checking the druid code hope this is helpful
   
   In DruidPlanner.java -> plan()
   we have 2 functions
   planWithDruidConvention() -> this is for normal tables/datasources
   planWithBindableConvention() -> this is for bindable tables i.e. metadata 
table
   
   > `SELECT LATEST(channel,10),cityName FROM "wikipedia" WHERE (comment IN( 
'added project') ) and (comment NOT IN ('added project' )) GROUP BY cityName`
   
   for the above query
   In 0.21.1 
   
   -  the plan fails in planWithDruidConvention() with the follwoing exception 
and goes to planWithBindableConvention() as a fallback
   - > org.apache.calcite.plan.RelOptPlanner$CannotPlanException: There are not 
enough rules to produce a node with desired properties: convention=DRUID, 
sort=[].
   
   In 24.0 
   
   - I can see changes in decision path(`if (!bindableTables.isEmpty()) { }`). 
   - the plan goes to planWithDruidConvention() and it fails
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to