[
https://issues.apache.org/jira/browse/CALCITE-1000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1000:
---------------------------------
Fix Version/s: (was: 1.4.0-incubating)
> How to use @ symbol in SQL QUery
> --------------------------------
>
> Key: CALCITE-1000
> URL: https://issues.apache.org/jira/browse/CALCITE-1000
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.4.0-incubating
> Environment: java7
> Reporter: Raghavender
> Assignee: Julian Hyde
>
> I am unable to execute sql query when query has @ symbol which generally we
> use to declare placeholders. I am getting below error.
> query:
> "insert into planning_point_data_cache
> (ts_business_name_id,planning_point_seq,detail_id,detail_id,period_id,cache_value)"
> +
> " select
> ppd.ts_business_name_id,denorm.input_ppt_cache_seq,denorm.detail_id,denorm.period_id,sum(ppd.\"VALUE\")
> " +
> "from rule_output_input_map_normalize denorm
> join planning_point_data ppd on denorm.input_ppt_seq=ppd.planning_point_seq" +
> " where denorm.param_order= @PARAM_ID and
> denorm.input_ppt_cache_seq>0 group by ppd.ts_business_name_id";
>
>
> Here goes
> org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1,
> column 377. Encountered: "@" (64), after : ""
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:388)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:118)
> at
> org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:130)
> at TestSqlParser.main(TestSqlParser.java:29)
> Caused by: org.apache.calcite.sql.parser.impl.TokenMgrError: Lexical error at
> line 1, column 377. Encountered: "@" (64), after : ""
> at
> org.apache.calcite.sql.parser.impl.SqlParserImplTokenManager.getNextToken(SqlParserImplTokenManager.java:13787)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_scan_token(SqlParserImpl.java:16484)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_225(SqlParserImpl.java:10737)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_83(SqlParserImpl.java:10726)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_217(SqlParserImpl.java:10980)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_82(SqlParserImpl.java:11001)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_112(SqlParserImpl.java:11723)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_67(SqlParserImpl.java:11730)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_190(SqlParserImpl.java:12161)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3R_62(SqlParserImpl.java:12139)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_181(SqlParserImpl.java:12264)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_184(SqlParserImpl.java:12588)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_3_185(SqlParserImpl.java:12603)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_2_185(SqlParserImpl.java:6514)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression2(SqlParserImpl.java:2396)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.Expression(SqlParserImpl.java:2366)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.WhereOpt(SqlParserImpl.java:1867)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlSelect(SqlParserImpl.java:822)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.LeafQuery(SqlParserImpl.java:578)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.LeafQueryOrExpr(SqlParserImpl.java:2351)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.QueryOrExpr(SqlParserImpl.java:2270)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.OrderedQueryOrExpr(SqlParserImpl.java:496)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlInsert(SqlParserImpl.java:1009)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:754)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:776)
> at
> org.apache.calcite.sql.parser.impl.SqlParserImpl.parseSqlStmtEof(SqlParserImpl.java:177)
> at
> org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:123)
> ... 1 more
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
