YellowStallion opened a new issue, #2981: URL: https://github.com/apache/drill/issues/2981
I'm running Drill 1.21.2 on Windows and having problems using the Pagination functionality of the http storage plugin when querying an ODATA source. The $skip and $top parameters are being appended to the URL of each request, so that I see requests like this: URL: https://services.odata.org/V4/Northwind/Northwind.svc/Customers?%24skip=0&%24top=15&%24skip=15&%24top=15 The %24skip=0&%24top=15 should not be present, only the %24skip=15&%24top=15 To reproduce, create a storage plugin called customers, with this config: { "type": "http", "connections": { "customers": { "url": "https://services.odata.org/V4/Northwind/Northwind.svc/Customers";, "requireTail": false, "method": "GET", "dataPath": "value", "authType": "none", "inputType": "json", "xmlDataLevel": 1, "postParameterLocation": "QUERY_STRING", "verifySSLCert": true, "paginator": { "limitParam": "$top", "offsetParam": "$skip", "pageSize": 15, "method": "OFFSET" } } }, "retryDelay": 1000, "proxyType": "direct", "authMode": "SHARED_USER", "enabled": true } Then run this query: select * from customers.`customers`; This is the error I'm seeing: org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: Error parsing JSON - Unexpected character ('<' (code 60)): expected a valid value (JSON String, Number (or 'NaN'/'+INF'/'-INF'), Array, Object or token 'null', 'true' or 'false') at [Source: REDACTED (`StreamReadFeature.INCLUDE_SOURCE_IN_LOCATION` disabled); line: 1, column: 2] Syntax error Connection: customers Plugin: customers URL: https://services.odata.org/V4/Northwind/Northwind.svc/Customers?%24skip=0&%24top=15&%24skip=15&%24top=15 Fragment: 0: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: dev-unsubscr...@drill.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
