abhishekagarwal87 commented on issue #13240: URL: https://github.com/apache/druid/issues/13240#issuecomment-1285205003
Yes. Its the same issue. While there is a time filter, sql planner removed it since the whole WHERE condition is impossible. On Thu, 20 Oct 2022 at 2:21 PM, sachidananda007 ***@***.***> wrote: > HI @abhishekagarwal87 <https://github.com/abhishekagarwal87> > Thanks for the quick reply > i have one more question . > *I have this following query which has filtering on time.* > > SELECT DATE_TRUNC('month',t0.__time),SUM(delta) FROM "wikipedia" t0 > WHERE t0.__time BETWEEN MILLIS_TO_TIMESTAMP(1441888496000) AND MILLIS_TO_TIMESTAMP(1442752496000) > and (comment IN( 'added project') ) > and ( NOT(comment IN ('added project' ))) > GROUP BY DATE_TRUNC('month',t0.__time) > > this is also showing similar results(timeout) fails in 0.22.1,0.23.0 and > 24.0.0. but passes in 0.21.1 > > Can you please confirm if the above query also has similar issue mention > in the pr https://github.com/apache/druid/pull/12944/files > > or it is a different issue? > > — > Reply to this email directly, view it on GitHub > <https://github.com/apache/druid/issues/13240#issuecomment-1285166963>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AALIWUMHFVY4JAGXEPO5XG3WEEBZHANCNFSM6AAAAAARJDPROE> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> > -- 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]
