suneet-s opened a new issue #9699: EXPLAIN SQL query with no limit generates invalid query URL: https://github.com/apache/druid/issues/9699 Please provide a detailed title (e.g. "Broker crashes when using TopN query with Bound filter" instead of just "Broker crashes"). ### Affected Version Tested in 0.18, haven't verified in older versions ### Description If you use the web console's explain feature for a query with smart limits disabled it generates an invalid SQL query ``` SELECT * from wikipedia ``` generates ``` { "queryType": "scan", "dataSource": { "type": "table", "name": "wikipedia" }, "intervals": { "type": "intervals", "intervals": [ "-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z" ] }, "virtualColumns": [], "resultFormat": "compactedList", "batchSize": 20480, "limit": 9223372036854776000, "order": "none", "filter": null, "columns": [ "__time", "channel", "cityName", "comment", "count", "countryIsoCode", "countryName", "diffUrl", "flags", "isAnonymous", "isMinor", "isNew", "isRobot", "isUnpatrolled", "namespace", "page", "regionIsoCode", "regionName", "sum_added", "sum_blah", "sum_blah2", "sum_blah3", "sum_commentLength", "sum_deleted", "sum_delta", "sum_deltaBucket", "user" ], "legacy": false, "context": { "sqlQueryId": "cc783735-4d86-4c29-aab3-77df8b93334f" }, "descending": false, "granularity": { "type": "all" } } ``` which fails with ``` Numeric value (9223372036854776000) out of range of long (-9223372036854775808 - 9223372036854775807) at [Source: (org.eclipse.jetty.server.HttpInputOverHTTP); line: 1, column: 257] (through reference chain: org.apache.druid.query.scan.ScanQuery["limit"]) ```
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
