[jira] [Created] (CALCITE-1131) Getting error Non-query expression encountered in illegal context

["Shyam (JIRA)" <ji...@apache.org>]

Shyam created CALCITE-1131:
------------------------------

             Summary: 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)