https://pinot.apache.org/ logo
Join Slack
Powered by
Hi all I get this error while doing a join query A...
# troubleshooting
d
Hi all I get this error while doing a join query A simple Join Query
Copy code
select a.name from table1 as a JOIN table2 as b on a.name=b.name
Server logs:
Copy code
Handled request from 0:0:0:0:0:0:0:1 POST <http://localhost:9000/sql>, content-type application/json; charset=UTF-8 status code 200 OK
Timed out after polling mailboxes: [Server_172.24.254.223_8098]
query execution failed
java.lang.RuntimeException: Received error query execution result block: {250=ExecutionTimeoutError}
	at org.apache.pinot.query.service.QueryDispatcher.reduceMailboxReceive(QueryDispatcher.java:133) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.apache.pinot.query.service.QueryDispatcher.submitAndReduce(QueryDispatcher.java:73) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:161) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:127) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.apache.pinot.broker.requesthandler.BrokerRequestHandler.handleRequest(BrokerRequestHandler.java:47) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.apache.pinot.broker.requesthandler.BrokerRequestHandlerDelegate.handleRequest(BrokerRequestHandlerDelegate.java:101) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.apache.pinot.broker.api.resources.PinotClientRequest.executeSqlQuery(PinotClientRequest.java:224) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.apache.pinot.broker.api.resources.PinotClientRequest.processSqlQueryPost(PinotClientRequest.java:146) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
	at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
	at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
	at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.lambda$apply$0(ResourceMethodInvoker.java:387) ~[pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.ServerRuntime$AsyncResponder$2$1.run(ServerRuntime.java:816) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:244) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at org.glassfish.jersey.server.ServerRuntime$AsyncResponder$2.run(ServerRuntime.java:811) [pinot-all-0.12.0-SNAPSHOT-jar-with-dependencies.jar:0.12.0-SNAPSHOT-61fc9190bc1c2f15b3775acf892689a30da6df5e]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
@Rong R Can you help me?
r
could you give me the query?
d
Copy code
select a.name from table1 as a JOIN table2 as b on a.name=b.name
This is the query I changed the table name alone from my side
r
thx let me debug
but you didn't select out anything on b. nor did you add any filter. the result will be the same as select a.name from table1
since we don't support limit yet. the error would very much b/c you selected too many data out
d
same error
Copy code
select a.name,b.name from table1 as a JOIN table2 as b on a.name=b.name
r
what's the data size of your system?
e.g. table a and table b
and cardinality of the name field
d
Total Table Count : 52531 count(*) Cardinality of name : 45962 count(name)
Do i need to provide any other result to u?
r
can't reproduce actually. any other info you can provide?
d
System RAM ->16 GB
Other than I am using groovy,timestamp , startree and some other indexes for that table
Does it helps you?
If i apply limit it works but for you without limit working I don't know whats the issue?
r
could you try the new master and rebuild? still can't reproduce. also limit works for me as well
d
@Rong R Still receiving the same Can you have any other approach? Can we change ExecutionTimeout? Is there a way out?
r
can you share me the exact query, table config json, data schema json? I can try to reproduce
d
Ok I will share u
Open in Slack
PreviousNext
Powered by