Dandandan commented on issue #20601: URL: https://github.com/apache/datafusion/issues/20601#issuecomment-3991961128
`SELECT * FROM hits WHERE "URL" LIKE '%google%' ORDER BY "EventTime" LIMIT 10; ` For this one we could do it probably faster by `SELECT * FROM hits WHERE (EventTime in (SELECT EventTime FROM hits WHERE "URL" LIKE '%google%' ORDER BY "EventTime" LIMIT 10) AND "URL" LIKE '%google%' ORDER BY "EventTime" LIMIT 10; -- 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]
