drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-501) Drill fails to parse absolute value "@" in query
Date Mon, 19 May 2014 17:46:39 GMT

    [ https://issues.apache.org/jira/browse/DRILL-501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14002054#comment-14002054
] 

Krystal commented on DRILL-501:
-------------------------------

git.commit.id.abbrev=70fab8c

The query still fails with the latest build.

select @(gpa - student_id) from student where student_id=10;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"c71a4e00-e476-4f5c-9f5d-14d2fe0a6d1c"
endpoint {
  address: "qa-node64.qa.lab"
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Lexical error at line 1, column
8.  Encountered: "@" (64), after : "" ] < TokenMgrError:[ Lexical error at line 1, column
8.  Encountered: "@" (64), after : "" ]"

Stack trace:
org.apache.drill.exec.planner.sql.parser.impl.TokenMgrError: Lexical error at line 1, column
8.  Encountered: "@" (64), after : ""
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImplTokenManager.getNextToken(DrillParserImplTokenManager.java:13785)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_scan_token(DrillParserImpl.java:16417)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_3_446(DrillParserImpl.java:11001)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_3R_65(DrillParserImpl.java:11011)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_3_166(DrillParserImpl.java:12586)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_3R_107(DrillParserImpl.java:12639)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_3R_27(DrillParserImpl.java:14196)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_3_23(DrillParserImpl.java:12670)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.jj_2_23(DrillParserImpl.java:5369)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlStmt(DrillParserImpl.java:693)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.SqlStmtEof(DrillParserImpl.java:736)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.parser.impl.DrillParserImpl.parseSqlStmtEof(DrillParserImpl.java:123)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.eigenbase.sql.parser.SqlParser.parseStmt(SqlParser.java:143) ~[optiq-core-0.7-20140513.013236-5.jar:na]
net.hydromatic.optiq.prepare.PlannerImpl.parse(PlannerImpl.java:164) ~[optiq-core-0.7-20140513.013236-5.jar:na]
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:112) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:338) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:186) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]

> Drill fails to parse absolute value "@" in query
> ------------------------------------------------
>
>                 Key: DRILL-501
>                 URL: https://issues.apache.org/jira/browse/DRILL-501
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.0.0
>            Reporter: Krystal
>         Attachments: student.parquet
>
>
> Ran the following query:
> select @(gpa - rownum) from student where rownum=10;
> Got the following error:
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"727a0a12-44b5-4d51-aeb2-533543029e6b"
> endpoint {
>   address: "qa-node57.qa.lab"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < SqlParseException:[ Lexical error at line 1,
column 8.  Encountered: \"@\" (64), after : \"\" ] < TokenMgrError:[ Lexical error at line
1, column 8.  Encountered: \"@\" (64), after : \"\" ]"
> ]



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message