https://pinot.apache.org/ logo
j

jainendra tarun

06/16/2021, 4:59 PM
Hello everyone, I am running Presto to query Pinot and the presto-pinot connector throws an exception when there is no data returned by Pinot. Example query is :
Copy code
select * from pinot.default.mytable where where datekey='2021-04-19 00:00:00' limit 10
Though this query returns empty result in Pinot as expected. The exception in presto is :
Copy code
java.lang.IllegalStateException: Expected at least one row to be present
	at com.google.common.base.Preconditions.checkState(Preconditions.java:507)
	at com.facebook.presto.pinot.PinotBrokerPageSourceSql.populateFromQueryResults(PinotBrokerPageSourceSql.java:118)
	at com.facebook.presto.pinot.PinotBrokerPageSourceBase.lambda$issueQueryAndPopulate$0(PinotBrokerPageSourceBase.java:327)
	at com.facebook.presto.pinot.PinotUtils.doWithRetries(PinotUtils.java:39)
	at com.facebook.presto.pinot.PinotBrokerPageSourceBase.issueQueryAndPopulate(PinotBrokerPageSourceBase.java:312)
	at com.facebook.presto.pinot.PinotBrokerPageSourceBase.getNextPage(PinotBrokerPageSourceBase.java:222)
	at com.facebook.presto.operator.TableScanOperator.getOutput(TableScanOperator.java:252)
	at com.facebook.presto.operator.Driver.processInternal(Driver.java:418)
	at com.facebook.presto.operator.Driver.lambda$processFor$9(Driver.java:301)
	at com.facebook.presto.operator.Driver.tryWithLock(Driver.java:722)
	at com.facebook.presto.operator.Driver.processFor(Driver.java:294)
	at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:1077)
	at com.facebook.presto.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:162)
	at com.facebook.presto.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:599)
	at com.facebook.presto.$gen.Presto_0_256_SNAPSHOT_5059796____20210616_162510_1.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Is this a bug or am I missing some configuration ?
x

Xiang Fu

06/16/2021, 6:24 PM
This is a bug that @Dharak Kharod is working on.
👍 1
we should have it fixed soon
j

jainendra tarun

06/17/2021, 2:33 PM
@Xiang Fu @Dharak Kharod Is there any place where I can follow this?