You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/03/08 21:11:40 UTC
[jira] [Updated] (CALCITE-1131) Getting error Non-query expression
encountered in illegal context
[ https://issues.apache.org/jira/browse/CALCITE-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde updated CALCITE-1131:
---------------------------------
Labels: (was: patch)
> Getting error Non-query expression encountered in illegal context
> -----------------------------------------------------------------
>
> Key: CALCITE-1131
> URL: https://issues.apache.org/jira/browse/CALCITE-1131
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.4.0-incubating
> Reporter: Shyam
> Assignee: Julian Hyde
> Fix For: 1.4.0-incubating
>
>
> Trying to parse below query string
> INSERT ignore INTO temp_ppd (job_id, planning_point_seq, detail_id, ts_business_name_id, period_id, value, audit_id, is_user_override,is_computed) SELECT DISTINCT @JOB_ID, denorm.output_ppt_seq, denorm.detail_id, denorm.ts_business_name_id, denorm.period_id, case when ( isnull(view1.c1_numeric_05,0) ) = 1.0 then isnull(ppd3.value,0) else isnull(ppd2.value,0) end, rii.audit_id, 0 is_user_override,Cast (1 AS TINYINT) is_computed FROM rule_input_interface_@JOB_ID rii JOIN rule_output_input_map_denormalize denorm ON rii.output_ppt_seq = denorm.output_ppt_seq JOIN VWSEARCH_VIEW view1 ON view1.DETAIL_ID = denorm.detail_id left join planning_point_data ppd2 on ppd2.planning_point_seq = denorm.param2_ppt_seq and ppd2.ts_business_name_id = 111 left join planning_point_data ppd3 on ppd3.planning_point_seq = denorm.param3_ppt_seq and ppd3.ts_business_name_id = 323 WHERE denorm.ts_business_name_id = 130 and rii.ts_business_name_id = 130 and rii.batch_id=@BATCH_ID; INSERT ignore INTO temp(job_id, rundate) value(@JOB_ID ,now());
> But getting
> SEVERE: org.apache.calcite.runtime.CalciteContextException: At line 1, column 63: Non-query expression encountered in illegal context
> 2016-03-09 00:08:35 ERROR [http-bio-8080-exec-3] (ImpalaScriptParser.java:74) - org.apache.calcite.sql.parser.SqlParseException: Non-query expression encountered in illegal context
> 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 com.steelwedge.calcite.ImpalaScriptParser.isImpalaCompiled(ImpalaScriptParser.java:67)
> Please help me , how to resolve this issue ?
> What went wrong here ?
> thank you.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)