When I try to use the query engine normally the qu...
# troubleshooting
j
When I try to use the query engine normally the query seems to be working. But when I try out the V2 query engine I am getting the following error
Copy code
[
  {
    "message": "QueryExecutionError:\njava.lang.RuntimeException: Received error query execution result block: {230=ServerTableMissing:\nFailed to find table: SegmentMembership on server: Server_172.20.0.11_8098}\n\tat org.apache.pinot.query.service.QueryDispatcher.reduceMailboxReceive(QueryDispatcher.java:133)\n\tat org.apache.pinot.query.service.QueryDispatcher.submitAndReduce(QueryDispatcher.java:73)\n\tat org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:156)",
    "errorCode": 200
  }
]
But I see the table is in good state with the segments present in all the configured servers including the server mentioned in the log.
Response from query console
Copy code
{
  "exceptions": [
    {
      "message": "QueryExecutionError:\njava.lang.RuntimeException: Received error query execution result block: {230=ServerTableMissing:\nFailed to find table: SegmentMembership on server: Server_172.20.0.10_8098}\n\tat org.apache.pinot.query.service.QueryDispatcher.reduceMailboxReceive(QueryDispatcher.java:133)\n\tat org.apache.pinot.query.service.QueryDispatcher.submitAndReduce(QueryDispatcher.java:73)\n\tat org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:156)",
      "errorCode": 200
    }
  ],
  "numServersQueried": 0,
  "numServersResponded": 0,
  "numSegmentsQueried": 0,
  "numSegmentsProcessed": 0,
  "numSegmentsMatched": 0,
  "numConsumingSegmentsQueried": 0,
  "numConsumingSegmentsProcessed": 0,
  "numConsumingSegmentsMatched": 0,
  "numDocsScanned": 0,
  "numEntriesScannedInFilter": 0,
  "numEntriesScannedPostFilter": 0,
  "numGroupsLimitReached": false,
  "totalDocs": 0,
  "timeUsedMs": 0,
  "offlineThreadCpuTimeNs": 0,
  "realtimeThreadCpuTimeNs": 0,
  "offlineSystemActivitiesCpuTimeNs": 0,
  "realtimeSystemActivitiesCpuTimeNs": 0,
  "offlineResponseSerializationCpuTimeNs": 0,
  "realtimeResponseSerializationCpuTimeNs": 0,
  "offlineTotalCpuTimeNs": 0,
  "realtimeTotalCpuTimeNs": 0,
  "segmentStatistics": [],
  "traceInfo": {},
  "minConsumingFreshnessTimeMs": 0,
  "numSegmentsPrunedByBroker": 0,
  "numSegmentsPrunedByServer": 0,
  "numSegmentsPrunedInvalid": 0,
  "numSegmentsPrunedByLimit": 0,
  "numSegmentsPrunedByValue": 0,
  "explainPlanNumEmptyFilterSegments": 0,
  "explainPlanNumMatchAllFilterSegments": 0,
  "numRowsResultSet": 0
}
m
@Rong R ^^
r
could you share your exact query?
j
@Rong R this was the query I was trying to exeute
Copy code
select count(s1.member_id) from SegmentMembership s1 join SegmentMembership s2 on s1.member_id = s2.member_id where s1.segment_id='seg0' and s2.segment_id != 'seg0' group by s2.segment_id;
r
we just supported hybrid table last week. so you would have to build from latest master and try again
previously we only support offline tables and you will have to manually append
_OFFLINE
to the table name
j
got it let me try that 👍