You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Shan Sikdar (JIRA)" <ji...@apache.org> on 2019/05/17 20:24:00 UTC
[jira] [Created] (DRILL-7266) adding semicolon in query when using
DRILL REST API causes an error
Shan Sikdar created DRILL-7266:
----------------------------------
Summary: adding semicolon in query when using DRILL REST API causes an error
Key: DRILL-7266
URL: https://issues.apache.org/jira/browse/DRILL-7266
Project: Apache Drill
Issue Type: Bug
Environment: MAC OSX using docker
Reporter: Shan Sikdar
Not sure if this is a bug or intended behavior.
Using the Drill REST API query.json endpoint, inside the query parameter adding a semicolon ; at the end of a query statement will cause an error to be returned. While making the query with no semicolon will work normally.
To reproduce:
Running the docker container
```
$ docker run -i -p 8047:8047 --detach -t drill/apache-drill:1.16.0 /bin/bash
8571e69831bcb731f61c40eb5219be9b624e78d79ad76069bee0a3ed04a70c1a
$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
8571e69831bc drill/apache-drill:1.16.0 "/bin/sh -c /opt/dri..." 3 seconds ago Up 2 seconds 0.0.0.0:8047->8047/tcp optimistic_greider
```
Here if I put a semicolon at the end of the query, it errors out:
```
$ curl -X POST -H "Content-Type: application/json" -d '\{"queryType":"SQL", "query": "select * from sys.version;", "autoLimit":1}' http://localhost:8047/query.json
{
"errorMessage" : "PARSE ERROR: Encountered \";\" at line 1, column 26.\nWas expecting one of:\n <EOF> \n \"ORDER\" ...\n \"LIMIT\" ...\n \"OFFSET\" ...\n \"FETCH\" ...\n \"NATURAL\" ...\n \"JOIN\" ...\n \"INNER\" ...\n \"LEFT\" ...\n \"RIGHT\" ...\n \"FULL\" ...\n \"CROSS\" ...\n \",\" ...\n \"OUTER\" ...\n \"(\" ...\n \"MATCH_RECOGNIZE\" ...\n <IDENTIFIER> ...\n <QUOTED_IDENTIFIER> ...\n <BACK_QUOTED_IDENTIFIER> ...\n <BRACKET_QUOTED_IDENTIFIER> ...\n <UNICODE_QUOTED_IDENTIFIER> ...\n \"TABLESAMPLE\" ...\n \"WHERE\" ...\n \"GROUP\" ...\n \"HAVING\" ...\n \"WINDOW\" ...\n \"UNION\" ...\n \"INTERSECT\" ...\n \"EXCEPT\" ...\n \"MINUS\" ...\n \".\" ...\n \"[\" ...\n \n\nSQL Query select * from sys.version;\n ^\n\n\n[Error Id: e12a2dc8-14da-46a1-be29-26eb507a9c0b ]"
```
Here if I put no semicolon and it works:
```
$ curl -X POST -H "Content-Type: application/json" -d '\{"queryType":"SQL", "query": "select * from sys.version", "autoLimit":1}' http://localhost:8047/query.json | jq
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 701 100 629 100 72 2727 312 --:--:-- --:--:-- --:--:-- 2734
{
"queryId": "23210500-99ed-9562-f956-12e189e0743f",
"columns": [
"version",
"commit_id",
"commit_message",
"commit_time",
"build_email",
"build_time"
],
"rows": [
{
"build_email": "agirish@apache.org",
"build_time": "06.05.2019 @ 17:29:53 PDT",
"commit_message": "[maven-release-plugin] prepare release drill-1.16.0",
"commit_time": "25.04.2019 @ 22:24:03 PDT",
"version": "1.16.0",
"commit_id": "751e87736c2ddbc184b52cfa56f4e29c68417cfe"
}
],
"metadata": [
"VARCHAR",
"VARCHAR",
"VARCHAR",
"VARCHAR",
"VARCHAR",
"VARCHAR"
],
"queryState": "COMPLETED",
"attemptedAutoLimit": 1
}
```
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)