Start a new topic

Case statement in ingestion to xDM

 I am trying to ingest Date from a flat csv file to xDM database. The database is MSSQL.

I can use a hard coded case statement ie (case when 1 = 1 then 1 else 0 end ) but when I try to add a variable from the flat file it gives me an error ie ( case when Flat_file.record = 'ok' then 1 else 0 end )  it gives me an error 

java.lang.ClassCastException: class net.sf.jsqlparser.expression.CaseExpression cannot be cast to class net.sf.jsqlparser.schema.Column (net.sf.jsqlparser.expression.CaseExpression and net.sf.jsqlparser.schema.Column are in unnamed module of loader com.indy.engine.core.module.classloader.StambiaClassLoaderRegistry$NamedURLClassLoader @7a79be86)
    at com.stambia.jdbc.driver.file.FileDriverStatement.verifySQLWithMetadata(
    at com.stambia.jdbc.driver.file.FileDriverStatement.executeSelect(
    at com.stambia.jdbc.driver.file.FileDriverStatement.executeStatement(
    at com.stambia.jdbc.driver.file.FileDriverStatement.executeQuery(
    at com.indy.engine.actionCodes.JdbcActionCodeI$1.initResultSet(
    at com.indy.engine.manager.ActionCodeExecutor.executeDirectBindedCode(
    at com.indy.engine.manager.ActionCodeExecutor.executeBindedCode(
    at com.indy.engine.manager.ActionCodeExecutor.executeCode(
    at java.base/

Does anyone have a solution

Login to post a comment