Closed sogwiz closed 5 years ago
Only getting 20 results back when I expect to receive 29 NOTE: Trying via Data Access Gateway Rest API, mapr dbshell, and the Go bindings all yield a result set of 29 documents. Only the python client code yields 20 results instead of 29
Config maprdb-python-client==1.1.1 mapr core = 6.1.0 mapr mep = 6.1.0
I believe the suspect code is: https://github.com/mapr/maprdb-python-client/blob/master/mapr/ojai/ojai/OJAIQueryResult.py#L33 in OJAIQueryResult.init -> for _ in range(10):
When I increase this hardcoded limit, the expected result set is returned; however, when I don't set this limit, I get a result set of 20 items back.
Query Info: query_dict = {"$select":["CourseID","CourseName","RaceID"],"$where":{"$like":{"RaceEntries.List[].DisplayName":"sargon%benjamin"}}}
DEBUG:mapr.ojai.storage.OJAIDocumentStore:Sending FIND request to the server. Request body: table_path: "/apps/course_results" payload_encoding: JSON_ENCODING include_query_plan: true json_query: "{\"$select\": [\"CourseID\", \"CourseName\", \"RaceID\"], \"$where\": {\"$like\": {\"RaceEntries.List[].DisplayName\": \"sargon%benjamin\"}}}"
{"QueryPlan":[[{"streamName":"DBDocumentStream","parameters":{"queryConditionPath":true,"indexName":"racer_displayname","projectionPath":["CourseID","RaceID","CourseName"],"primaryTable":"/apps/course_results"}},{"streamName":"DedupStream","parameters":{}}]]}
Only getting 20 results back when I expect to receive 29 NOTE: Trying via Data Access Gateway Rest API, mapr dbshell, and the Go bindings all yield a result set of 29 documents. Only the python client code yields 20 results instead of 29
Config maprdb-python-client==1.1.1 mapr core = 6.1.0 mapr mep = 6.1.0
I believe the suspect code is: https://github.com/mapr/maprdb-python-client/blob/master/mapr/ojai/ojai/OJAIQueryResult.py#L33 in OJAIQueryResult.init -> for _ in range(10):
When I increase this hardcoded limit, the expected result set is returned; however, when I don't set this limit, I get a result set of 20 items back.
Query Info: query_dict = {"$select":["CourseID","CourseName","RaceID"],"$where":{"$like":{"RaceEntries.List[].DisplayName":"sargon%benjamin"}}}
DEBUG:mapr.ojai.storage.OJAIDocumentStore:Sending FIND request to the server. Request body: table_path: "/apps/course_results" payload_encoding: JSON_ENCODING include_query_plan: true json_query: "{\"$select\": [\"CourseID\", \"CourseName\", \"RaceID\"], \"$where\": {\"$like\": {\"RaceEntries.List[].DisplayName\": \"sargon%benjamin\"}}}"
{"QueryPlan":[[{"streamName":"DBDocumentStream","parameters":{"queryConditionPath":true,"indexName":"racer_displayname","projectionPath":["CourseID","RaceID","CourseName"],"primaryTable":"/apps/course_results"}},{"streamName":"DedupStream","parameters":{}}]]}