https://pinot.apache.org/ logo
#general
Title
# general
h

Harshini Elath

02/14/2020, 10:52 PM
{ "selectionResults": { "columns": [ "audit_date" ], "results": [] }, "exceptions": [ { "errorCode": 200, "message": "QueryExecutionError\njava.lang.RuntimeException Caught exception while building data table.\n\tat org.apache.pinot.core.operator.blocks.InstanceResponseBlock.<init>(InstanceResponseBlock.java:46)\n\tat org.apache.pinot.core.operator.InstanceResponseOperator.getNextBlock(InstanceResponseOperator.java:37)\n\tat org.apache.pinot.core.operator.InstanceResponseOperator.getNextBlock(InstanceResponseOperator.java:26)\n\tat org.apache.pinot.core.operator.BaseOperator.nextBlock(BaseOperator.java:48)\n\tat org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:48)\n\tat org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:213)\n\tat org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:152)\n\tat org.apache.pinot.core.query.scheduler.QueryScheduler.lambda$createQueryFutureTask$0(QueryScheduler.java:136)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat shaded.com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:111)\n\tat shaded.com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:58)\n\tat shaded.com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:75)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)" }, { "errorCode": 200, "message": "QueryExecutionError\njava.lang.RuntimeException Caught exception while building data table.\n\tat org.apache.pinot.core.operator.blocks.InstanceResponseBlock.<init>(InstanceResponseBlock.java:46)\n\tat org.apache.pinot.core.operator.InstanceResponseOperator.getNextBlock(InstanceResponseOperator.java:37)\n\tat org.apache.pinot.core.operator.InstanceResponseOperator.getNextBlock(InstanceResponseOperator.java:26)\n\tat org.apache.pinot.core.operator.BaseOperator.nextBlock(BaseOperator.java:48)\n\tat org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:48)\n\tat org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:213)\n\tat org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:152)\n\tat org.apache.pinot.core.query.scheduler.QueryScheduler.lambda$createQueryFutureTask$0(QueryScheduler.java:136)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat shaded.com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:111)\n\tat shaded.com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:58)\n\tat shaded.com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:75)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)" } ], "numServersQueried": 2, "numServersResponded": 2, "numSegmentsQueried": 394, "numSegmentsProcessed": 0, "numSegmentsMatched": 0, "numConsumingSegmentsQueried": 0, "numDocsScanned": 0, "numEntriesScannedInFilter": 0, "numEntriesScannedPostFilter": 0, "numGroupsLimitReached": false, "totalDocs": 0, "timeUsedMs": 7, "segmentStatistics": [], "traceInfo": {}, "minConsumingFreshnessTimeMs": 0 }
x

Xiang Fu

02/14/2020, 10:58 PM
what is the results for
{"pql":"select audit_date from iw_audit where str_num=37126 "}
and
{"pql":"select count(audit_date) from iw_audit where str_num=37126 "}
h

Harshini Elath

02/14/2020, 11:02 PM
we get results for both queries
i just tried this and it is working too
Copy code
{
  "pql": "select count(audit_date) from iw_audit where str_num=37126 group by audit_date"
}
Copy code
{
  "aggregationResults": [
    {
      "groupByResult": [
        {
          "value": "2321",
          "group": [
            "2019-01-05"
          ]
        },
        {
          "value": "2232",
          "group": [
            "2019-03-16"
          ]
        },
        {
          "value": "2222",
          "group": [
            "2019-06-15"
          ]
        },
        {
          "value": "2129",
          "group": [
            "2019-09-07"
          ]
        },
        {
          "value": "2046",
          "group": [
            "2019-12-21"
          ]
        }
      ],
      "function": "count_star",
      "groupByColumns": [
        "audit_date"
      ]
    }
  ],
  "exceptions": [],
  "numServersQueried": 2,
  "numServersResponded": 2,
  "numSegmentsQueried": 394,
  "numSegmentsProcessed": 394,
  "numSegmentsMatched": 5,
  "numConsumingSegmentsQueried": 0,
  "numDocsScanned": 10950,
  "numEntriesScannedInFilter": 343046,
  "numEntriesScannedPostFilter": 10950,
  "numGroupsLimitReached": false,
  "totalDocs": 75492369,
  "timeUsedMs": 36,
  "segmentStatistics": [],
  "traceInfo": {},
  "minConsumingFreshnessTimeMs": 0
}
it is only not working with select distinct(col_name) with where condition
also; this problem is only with one table but it doesn't look any different.
x

Xiang Fu

02/14/2020, 11:17 PM
@Sidd Any idea?
will you be able to get the stacktrace from pinot server
h

Harshini Elath

02/15/2020, 3:15 AM
sure.. but can get in on monday only.
@Sidd @Xiang Fu