Khurram Faraaz created DRILL-7061: ------------------------------------- Summary: Selecting option to limit results to 1000 on web UI causes parse error Key: DRILL-7061 URL: https://issues.apache.org/jira/browse/DRILL-7061 Project: Apache Drill Issue Type: Bug Components: Web Server Affects Versions: 1.16.0 Reporter: Khurram Faraaz Attachments: image-2019-02-27-14-17-24-348.png
Selecting option to Limit results to 1,000 causes a parse error on web UI, screen shot is attached. Browser used was Chrome. Drill version => 1.16.0-SNAPSHOT commit = e342ff5 Error reported on web UI when we press Submit button on web UI {noformat} Query Failed: An Error Occurred org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: 'LIMIT start, count' is not allowed under the current SQL conformance level SQL Query -- [autoLimit: 1,000 rows] select * from ( select length(varStr) from dfs.`/root/many_json_files` ) limit 1,000 [Error Id: e252d1cc-54d4-4530-837c-a1726a5be89f on qa102-45.qa.lab:31010]{noformat} !image-2019-02-27-14-17-24-348.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)