pdeva edited a comment on issue #8041: Undocumented, seemingly random choosing of inital value timestamp for SQL results URL: https://github.com/apache/incubator-druid/issues/8041#issuecomment-509458217 simplied the query, so i can see the full exception. video: https://www.screencast.com/t/6urBmhP1rWHL Exception:  Update: pulled it from logs: ``` 2019-07-09 02:05:46,311 WARN o.a.d.s.h.SqlResource [sql[817122cf-6411-486e-a323-291f0ae973f3]] Failed to handle query: SqlQuery{query='SELECT * FROM (SELECT TIME_FLOOR("__time", 'PT50S','2019-07-09 00:07:00') as ts, (((SUM(cpu) *1000)/10000)/5) as cpuMetric, (SUM(mem_used)/5) as mem_used1, ((SUM(lim_cpu) *1000)/5) as lim_cpu1, ((SUM(req_cpu) *1000)/5) as req_cpu1, (SUM(lim_mem)/5) as lim_mem1, (SUM(req_mem)/5) as req_mem1, (SUM(mem_limit)/5) as mem_limit1 FROM "kube-metrics-second" WHERE "__time" >= TIMESTAMP '2019-07-09 00:07:00' AND "__time" < TIMESTAMP '2019-07-09 00:37:00' GROUP BY TIME_FLOOR("__time", 'PT50S','2019-07-09 00:07:00')) LIMIT 5000', resultFormat=ARRAY, header=true, context={useCache=false, populateCache=false}} java.lang.RuntimeException: Error while applying rule DruidQueryRule(SELECT_PROJECT), args [rel#6665063:LogicalProject.NONE.[](input=rel#6665061:Subset#8.NONE.[],ts=TIME_FLOOR($0, 'PT50S', '2019-07-09 00:07:00'),cpu=$10,mem_used=$17,lim_cpu=$14,req_cpu=$25,lim_mem=$15,req_mem=$26,mem_limit=$16), rel#6665073:DruidQueryRel.NONE.[](query={"queryType":"scan","dataSource":{"type":"table","name":"kube-metrics-second"},"intervals":{"type":"intervals","intervals":["2019-07-09T00:07:00.000Z/2019-07-09T00:37:00.000Z"]},"virtualColumns":[],"resultFormat":"compactedList","batchSize":20480,"limit":9223372036854775807,"filter":null,"columns":["__time","accountid","alloc_cpu","alloc_mem","alloc_pods","cap_cpu","cap_mem","cap_pods","cluster","count","cpu","etype","image","labels","lim_cpu","lim_mem","mem_limit","mem_used","name","namespace","node","node_pool","owner","owner_kind","pod","req_cpu","req_mem","rxBytes","txBytes"],"legacy":false,"context":{"populateCache":false,"sqlQueryId":"817122cf-6411-486e-a323-291f0ae973f3","useCache":false},"descending":false,"granularity":{"type":"all"}},signature={__time:LONG, accountid:STRING, alloc_cpu:FLOAT, alloc_mem:LONG, alloc_pods:FLOAT, cap_cpu:FLOAT, cap_mem:LONG, cap_pods:FLOAT, cluster:STRING, count:LONG, cpu:DOUBLE, etype:STRING, image:STRING, labels:STRING, lim_cpu:FLOAT, lim_mem:LONG, mem_limit:LONG, mem_used:LONG, name:STRING, namespace:STRING, node:STRING, node_pool:STRING, owner:STRING, owner_kind:STRING, pod:STRING, req_cpu:FLOAT, req_mem:LONG, rxBytes:LONG, txBytes:LONG})] at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:236) ~[calcite-core-1.17.0-iap1.jar:1.17.0-iap1] at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:646) ~[calcite-core-1.17.0-iap1.jar:1.17.0-iap1] at org.apache.calcite.tools.Programs$RuleSetProgram.run(Programs.java:339) ~[calcite-core-1.17.0-iap1.jar:1.17.0-iap1] at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:358) ~[calcite-core-1.17.0-iap1.jar:1.17.0-iap1] at org.apache.calcite.prepare.PlannerImpl.transform(PlannerImpl.java:337) ~[calcite-core-1.17.0-iap1.jar:1.17.0-iap1] at org.apache.druid.sql.calcite.planner.DruidPlanner.planWithDruidConvention(DruidPlanner.java:122) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.planner.DruidPlanner.plan(DruidPlanner.java:92) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.SqlLifecycle.plan(SqlLifecycle.java:143) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.SqlLifecycle.plan(SqlLifecycle.java:154) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.SqlLifecycle.planAndAuthorize(SqlLifecycle.java:220) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.http.SqlResource.doPost(SqlResource.java:92) [druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_181] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) [jersey-server-1.19.3.jar:1.19.3] at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) [jersey-servlet-1.19.3.jar:1.19.3] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558) [jersey-servlet-1.19.3.jar:1.19.3] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733) [jersey-servlet-1.19.3.jar:1.19.3] at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [javax.servlet-api-3.1.0.jar:3.1.0] at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:286) [guice-servlet-4.1.0.jar:?] at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:276) [guice-servlet-4.1.0.jar:?] at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:181) [guice-servlet-4.1.0.jar:?] at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91) [guice-servlet-4.1.0.jar:?] at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85) [guice-servlet-4.1.0.jar:?] at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:120) [guice-servlet-4.1.0.jar:?] at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:135) [guice-servlet-4.1.0.jar:?] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642) [jetty-servlet-9.4.10.v20180503.jar:9.4.10.v20180503] at org.apache.druid.server.security.PreResponseAuthorizationCheckFilter.doFilter(PreResponseAuthorizationCheckFilter.java:82) [druid-server-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642) [jetty-servlet-9.4.10.v20180503.jar:9.4.10.v20180503] at org.apache.druid.server.security.AllowOptionsResourceFilter.doFilter(AllowOptionsResourceFilter.java:75) [druid-server-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642) [jetty-servlet-9.4.10.v20180503.jar:9.4.10.v20180503] at org.apache.druid.server.security.AllowAllAuthenticator$1.doFilter(AllowAllAuthenticator.java:84) [druid-server-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.server.security.AuthenticationWrappingFilter.doFilter(AuthenticationWrappingFilter.java:59) [druid-server-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642) [jetty-servlet-9.4.10.v20180503.jar:9.4.10.v20180503] at org.apache.druid.server.security.SecuritySanityCheckFilter.doFilter(SecuritySanityCheckFilter.java:86) [druid-server-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642) [jetty-servlet-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533) [jetty-servlet-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473) [jetty-servlet-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:724) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.Server.handle(Server.java:531) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260) [jetty-server-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281) [jetty-io-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102) [jetty-io-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118) [jetty-io-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333) [jetty-util-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310) [jetty-util-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168) [jetty-util-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126) [jetty-util-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366) [jetty-util-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760) [jetty-util-9.4.10.v20180503.jar:9.4.10.v20180503] at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678) [jetty-util-9.4.10.v20180503.jar:9.4.10.v20180503] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181] Caused by: org.apache.druid.java.util.common.IAE: Expected literal but got[LITERAL] at org.apache.druid.sql.calcite.planner.Calcites.calciteDateTimeLiteralToJoda(Calcites.java:303) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.expression.builtin.TimeFloorOperatorConversion.lambda$toDruidExpression$0(TimeFloorOperatorConversion.java:142) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.expression.OperatorConversions.getOperandWithDefault(OperatorConversions.java:121) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.expression.builtin.TimeFloorOperatorConversion.toDruidExpression(TimeFloorOperatorConversion.java:139) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.expression.Expressions.toDruidExpression(Expressions.java:166) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.rel.DruidQuery.computeSelectProjection(DruidQuery.java:208) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.rel.DruidQuery.<init>(DruidQuery.java:144) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.rel.PartialDruidQuery.build(PartialDruidQuery.java:332) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.rel.DruidQueryRel.toDruidQuery(DruidQueryRel.java:98) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.rel.DruidQueryRel.toDruidQueryForExplaining(DruidQueryRel.java:110) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.rel.DruidRel.isValidDruidQuery(DruidRel.java:69) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.druid.sql.calcite.rule.DruidRules$DruidQueryRule.onMatch(DruidRules.java:137) ~[druid-sql-0.14.0-incubating-iap10.jar:0.14.0-incubating-iap10] at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:212) ~[calcite-core-1.17.0-iap1.jar:1.17.0-iap1] ... 74 more ```
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
