Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1131

Getting error Non-query expression encountered in illegal context

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Invalid
    • 1.4.0-incubating
    • 1.7.0
    • core
    • None

    Description

      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.

      Attachments

        Activity

          People

            julianhyde Julian Hyde
            ShyamP Shyam
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: