walterddr commented on issue #11651: URL: https://github.com/apache/pinot/issues/11651#issuecomment-1762238266
automating hints are a much wider topic (getting cost-factory to hook-in, getting table metadata to feed into cost factory etc) and i would like to keep that separate. but to answer your question, auto setting join to lookup if RHS is dim table doesn't work --> - there's no guarantee the left side is a normal table, or a join result, or a temp table, etc. - there's also situation that LHS is a semi-join result following by a LOOKUP, which can apply automatically but can't be determine until we have cost-factory and table metadata feed in. -- 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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org