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.facebook.presto.pinot.PinotBrokerPageSourceSql.populateFromQueryResults(
	at com.facebook.presto.pinot.PinotBrokerPageSourceBase.lambda$issueQueryAndPopulate$0(
	at com.facebook.presto.pinot.PinotUtils.doWithRetries(
	at com.facebook.presto.pinot.PinotBrokerPageSourceBase.issueQueryAndPopulate(
	at com.facebook.presto.pinot.PinotBrokerPageSourceBase.getNextPage(
	at com.facebook.presto.operator.TableScanOperator.getOutput(
	at com.facebook.presto.operator.Driver.processInternal(
	at com.facebook.presto.operator.Driver.lambda$processFor$9(
	at com.facebook.presto.operator.Driver.tryWithLock(
	at com.facebook.presto.operator.Driver.processFor(
	at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(
	at com.facebook.presto.execution.executor.PrioritizedSplitRunner.process(
	at com.facebook.presto.execution.executor.TaskExecutor$
	at com.facebook.presto.$ Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(
	at java.util.concurrent.ThreadPoolExecutor$
Is this a bug or am I missing some configuration ?

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

jainendra tarun

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