RuntimeException when planning query

1

Hello
We have strange error when run this query “(java.lang.RuntimeException) While invoking method 'public com.dremio.common.rel2sql.DremioRelToSqlConverter$Result com.dremio.common.rel2sql.DremioRelToSqlConverter.visit(org.apache.calcite.rel.core.Project)”

SELECT NUM_OPERACION,
       cast(SUBSTRING(NUM_OPERACION, 1, 10) as decimal) as num_prestamo,
       cast(RIGHT(NUM_OPERACION, 2) as integer)         as secuencial_ant,
       --F.SALDO_TOTAL       AS SALDO_K_ESTRUC,
       -- F.DIAS_VENC         AS DIAS_VENCIDO,
       trim(F.SUB_CALIFICACION)                         AS CALIFICACION_ACTUAL,
       F.PROVI_CONSTITUIDA                              AS PROVISION_CONSTITUIDA_ACTUAL,
       --diario
       trim(ESTATUS_CALIF_ACT)                          as ESTATUS_CALIF_ACT,
       DIAS_VENC_ACEL,
       trim(SUB_CALIFICACION_ACEL)                      as SUB_CALIFICACION_ACEL,
       PROVI_CONSTITUIDA_ACEL,
       trim(ESTATUS_CALIF_ACEL)                         as ESTATUS_CALIF_ACEL

FROM mupiprod.MUPI.RE_R4H_DET F

WHERE F.FEC_CREACION IN (SELECT MAX(X.FEC_CREACION)
                         FROM mupiprod.MUPI.RE_R4H_CAB X
                         WHERE X.FEC_DATOS = '2023-07-15')

I think that the problem is related to data type

58abcab9-34cc-476b-a9c5-466e6826bbf9.zip (14,3 KB)

2

Hello please can you help me @dch or @balaji.ramaswamy ?

3

@dacopan See a similar stack getting worked on, let me confirm if it is the same issue and respond back