Jonathan Meyer
06/30/2021, 1:58 PMMayank
Jonathan Meyer
06/30/2021, 2:00 PMMayank
Jonathan Meyer
06/30/2021, 2:05 PMMayank
Jonathan Meyer
06/30/2021, 2:06 PM0.8.0-SNAPSHOT-46009e152b8f56c244e415beefa81dbc626de7cb
)what's the query?NOK:
select * from test_communities where entityId = 47923728534576490
OK: select * from test_communities where entityId = 47923728366804330
Ken Krugler
06/30/2021, 2:09 PMselect * from test_communities where entityId = '47923728534576490'
?Jonathan Meyer
06/30/2021, 2:09 PMMayank
Jonathan Meyer
06/30/2021, 2:13 PMingestFromFile
API endpoint (unit testing)Where did you get the id to query from? If the id was from UI, it might have been incorrect to begin with due to UInissueIndeed, I copy pasted from the UI Which works for one ID, but not the others Do you recommend me another way ?
Mayank
Jonathan Meyer
06/30/2021, 2:20 PMcurl localhost:8099/query/sql -d '{"sql": "select * from test_communities"}' | jq .
{
"resultTable": {
"dataSchema": {
"columnNames": [
"communityId",
"entityId",
"entityType",
"parentDepartmentId"
],
"columnDataTypes": [
"STRING",
"LONG",
"STRING",
"STRING"
]
},
"rows": [
[
"604795e710fc330f65e9100e",
47923728366804330, <<< TEST ID.1
"user",
"null"
],
[
"604795e710fc330f65e9100e",
47923728534576490, <<< TEST ID.2
"user",
"null"
],
[
"604795e710fc330f65e9100c",
62535436887531140,
"department",
"de2ba60543be995f958e1e80"
],
[
"604795e710fc330f65e9100c",
62535436887531080,
"department",
"de2ba60543be995f958e1e80"
],
[
"604795e710fc330f65e9100c",
62535436954639944,
"department",
"de2ba60543be995f958e1e80"
],
[
"604795e710fc330f65e9100c",
47923728685571440,
"user",
"de2ba60543be995f958e1e80"
],
[
"604795e710fc330f65e9100c",
47923728803011950,
"user",
"de2ba60543be995f958e1e80"
],
[
"604795e710fc330f65e9100c",
62535436887531080,
"department",
"de2ba60543be995f958e1e46"
],
[
"604795e710fc330f65e9100c",
47923728685571440,
"user",
"de2ba60543be995f958e1e46"
],
[
"604795e710fc330f65e9100c",
62535436954639944,
"department",
"de2ba60943be995f958e1e47"
]
]
},
"exceptions": [],
"numServersQueried": 1,
"numServersResponded": 1,
"numSegmentsQueried": 1,
"numSegmentsProcessed": 1,
"numSegmentsMatched": 1,
"numConsumingSegmentsQueried": 0,
"numDocsScanned": 10,
"numEntriesScannedInFilter": 0,
"numEntriesScannedPostFilter": 40,
"numGroupsLimitReached": false,
"totalDocs": 17,
"timeUsedMs": 4,
"offlineThreadCpuTimeNs": 398035,
"realtimeThreadCpuTimeNs": 0,
"segmentStatistics": [],
"traceInfo": {},
"minConsumingFreshnessTimeMs": 0,
"numRowsResultSet": 10
}
Now take the first returned ID (entityid
) -> 47923728366804330
Query :
curl localhost:8099/query/sql -d '{"sql": "select * from test_communities WHERE entityId = 47923728366804330"}' | jq .
{
"resultTable": {
"dataSchema": {
"columnNames": [
"communityId",
"entityId",
"entityType",
"parentDepartmentId"
],
"columnDataTypes": [
"STRING",
"LONG",
"STRING",
"STRING"
]
},
"rows": [
[
"604795e710fc330f65e9100e",
47923728366804330,
"user",
"null"
]
]
},
"exceptions": [],
"numServersQueried": 1,
"numServersResponded": 1,
"numSegmentsQueried": 1,
"numSegmentsProcessed": 1,
"numSegmentsMatched": 1,
"numConsumingSegmentsQueried": 0,
"numDocsScanned": 1,
"numEntriesScannedInFilter": 17,
"numEntriesScannedPostFilter": 4,
"numGroupsLimitReached": false,
"totalDocs": 17,
"timeUsedMs": 4,
"offlineThreadCpuTimeNs": 342519,
"realtimeThreadCpuTimeNs": 0,
"segmentStatistics": [],
"traceInfo": {},
"minConsumingFreshnessTimeMs": 0,
"numRowsResultSet": 1
}
-> OK
Now take the second ID -> 47923728534576490
Query :
curl localhost:8099/query/sql -d '{"sql": "select * from test_communities WHERE entityId = 47923728534576490"}' | jq .
{
"resultTable": {
"dataSchema": {
"columnNames": [
"communityId",
"entityId",
"entityType",
"parentDepartmentId"
],
"columnDataTypes": [
"STRING",
"LONG",
"STRING",
"STRING"
]
},
"rows": []
},
"exceptions": [],
"numServersQueried": 1,
"numServersResponded": 1,
"numSegmentsQueried": 1,
"numSegmentsProcessed": 1,
"numSegmentsMatched": 0,
"numConsumingSegmentsQueried": 0,
"numDocsScanned": 0,
"numEntriesScannedInFilter": 0,
"numEntriesScannedPostFilter": 0,
"numGroupsLimitReached": false,
"totalDocs": 17,
"timeUsedMs": 10,
"offlineThreadCpuTimeNs": 383400,
"realtimeThreadCpuTimeNs": 0,
"segmentStatistics": [],
"traceInfo": {},
"minConsumingFreshnessTimeMs": 0,
"numRowsResultSet": 0
}
-> NOKMayank
47923728366804330
and 47923728534576490
from?Jonathan Meyer
06/30/2021, 2:26 PMentityId
(so, 2sd element from the arrays)"rows": [
[
"604795e710fc330f65e9100e",
>>>>> 47923728366804330 <<<<<,
"user",
"null"
],
Mayank
Jonathan Meyer
06/30/2021, 3:04 PMMayank
Jackie
06/30/2021, 4:44 PMJonathan Meyer
06/30/2021, 4:47 PMJackie
06/30/2021, 4:51 PMjq
?Jonathan Meyer
06/30/2021, 4:53 PMJackie
06/30/2021, 4:54 PMjackie@MacBook-Pro ~ % echo '12345543211234554321' | jq .
12345543211234554000
Jonathan Meyer
06/30/2021, 4:54 PMjq
was having the same issue as Pinot's UI, altering the LONG values...