xiangfu0 opened a new issue, #10558:
URL: https://github.com/apache/pinot/issues/10558
When query bytes column,
V1 gives HEX value of a bytes, e.g. `80c062bc98021f94f1404e9bda0f6b0202`
V2 gives a base64 encoded object: e.g. `{ "bytes":
"gMBivJgCH5TxQE6b2g9rAgI=" },` ← This also caused query console UI not render.
Sample query: `select * from starbucksStores order by name limit 1`
Full responses:
V1:
```
{
"resultTable": {
"dataSchema": {
"columnNames": [
"address",
"lat",
"location_st_point",
"lon",
"name"
],
"columnDataTypes": [
"STRING",
"FLOAT",
"BYTES",
"FLOAT",
"STRING"
]
},
"rows": [
[
"601 West Street_601 West 5th Avenue_Anchorage, Alaska
99501_907-277-2477",
61.21759,
"80c062bc98021f94f1404e9bda0f6b0202",
-149.89355,
"Starbucks - AK - Anchorage 00001"
]
]
},
"exceptions": [],
"numServersQueried": 1,
"numServersResponded": 1,
"numSegmentsQueried": 1,
"numSegmentsProcessed": 1,
"numSegmentsMatched": 1,
"numConsumingSegmentsQueried": 0,
"numConsumingSegmentsProcessed": 0,
"numConsumingSegmentsMatched": 0,
"numDocsScanned": 6443,
"numEntriesScannedInFilter": 0,
"numEntriesScannedPostFilter": 6447,
"numGroupsLimitReached": false,
"totalDocs": 6443,
"timeUsedMs": 58,
"offlineThreadCpuTimeNs": 0,
"realtimeThreadCpuTimeNs": 0,
"offlineSystemActivitiesCpuTimeNs": 0,
"realtimeSystemActivitiesCpuTimeNs": 0,
"offlineResponseSerializationCpuTimeNs": 0,
"realtimeResponseSerializationCpuTimeNs": 0,
"offlineTotalCpuTimeNs": 0,
"realtimeTotalCpuTimeNs": 0,
"segmentStatistics": [],
"traceInfo": {},
"numRowsResultSet": 1,
"minConsumingFreshnessTimeMs": 0,
"numSegmentsPrunedByBroker": 0,
"numSegmentsPrunedByServer": 0,
"numSegmentsPrunedInvalid": 0,
"numSegmentsPrunedByLimit": 0,
"numSegmentsPrunedByValue": 0,
"explainPlanNumEmptyFilterSegments": 0,
"explainPlanNumMatchAllFilterSegments": 0
}
```
V2:
```
{
"resultTable": {
"dataSchema": {
"columnNames": [
"$docId",
"$hostName",
"$segmentName",
"address",
"lat",
"location_st_point",
"lon",
"name"
],
"columnDataTypes": [
"INT",
"STRING",
"STRING",
"STRING",
"FLOAT",
"BYTES",
"FLOAT",
"STRING"
]
},
"rows": [
[
0,
"xiangs-mbp.attlocal.net",
"starbucksStores_OFFLINE_0",
"601 West Street_601 West 5th Avenue_Anchorage, Alaska
99501_907-277-2477",
61.21759,
{
"bytes": "gMBivJgCH5TxQE6b2g9rAgI="
},
-149.89355,
"Starbucks - AK - Anchorage 00001"
]
]
},
"stageStats": {
"1": {
"numBlocks": 10,
"numRows": 2,
"stageExecutionTimeMs": 4,
"stageExecutionUnit": 3,
"stageExecWallTimeMs": 5
},
"2": {
"numBlocks": 2,
"numRows": 1,
"stageExecutionTimeMs": 16,
"stageExecutionUnit": 2,
"stageExecWallTimeMs": 9,
"numSegmentsQueried": 1,
"numSegmentsProcessed": 1,
"numSegmentsMatched": 1,
"numDocsScanned": 6443,
"numEntriesScannedPostFilter": 6450,
"totalDocs": 6443,
"tableNames": [
"starbucksStores"
]
}
},
"exceptions": [],
"numServersQueried": 0,
"numServersResponded": 0,
"numSegmentsQueried": 1,
"numSegmentsProcessed": 1,
"numSegmentsMatched": 1,
"numConsumingSegmentsQueried": 0,
"numConsumingSegmentsProcessed": 0,
"numConsumingSegmentsMatched": 0,
"numDocsScanned": 6443,
"numEntriesScannedInFilter": 0,
"numEntriesScannedPostFilter": 6450,
"numGroupsLimitReached": false,
"totalDocs": 6443,
"timeUsedMs": 228,
"offlineThreadCpuTimeNs": 0,
"realtimeThreadCpuTimeNs": 0,
"offlineSystemActivitiesCpuTimeNs": 0,
"realtimeSystemActivitiesCpuTimeNs": 0,
"offlineResponseSerializationCpuTimeNs": 0,
"realtimeResponseSerializationCpuTimeNs": 0,
"offlineTotalCpuTimeNs": 0,
"realtimeTotalCpuTimeNs": 0,
"segmentStatistics": [],
"traceInfo": {},
"numRowsResultSet": 1,
"minConsumingFreshnessTimeMs": 0,
"numSegmentsPrunedByBroker": 0,
"numSegmentsPrunedByServer": 0,
"numSegmentsPrunedInvalid": 0,
"numSegmentsPrunedByLimit": 0,
"numSegmentsPrunedByValue": 0,
"explainPlanNumEmptyFilterSegments": 0,
"explainPlanNumMatchAllFilterSegments": 0
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
