[
https://issues.apache.org/jira/browse/CALCITE-1131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1131:
---------------------------------
Flags: (was: Important)
> 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)
