We recently migrated the pipelines from v6.1.1. to V6.3 on prem. We are reading a table from database and column has datatype - number(20,0). In CDAP wrangler, its datatype is bigdecimal and when we try to convert it to long and run the pipeline, we are receiving the following exception:
Schema field 'column' has type decimal with precision 38 and scale 0 but in input record found type decimal with precision 20 and scale 0
Problem converting into output record. Reason : Schema specifies field 'ID' is long, but the value is nor a string or long. It is of type 'BigDecimal',0,Wrangler_CIM_GENERIC [B@5513982,[B@22351330,[B@2158d1d1,1614553200000000,I,[B@72238cf0,[B@7e32261f,Nem járulok hozzá,,[B@7414167a,A,Problem converting into output record. Reason : Schema specifies field 'ID' is long, but the value is nor a string or long. It is of type 'BigDecimal',0,Wrangler_CIM_GENERIC
Because of this datatype issue, all records from input are going to error.
Same pipeline is working as expected in CDAP V6.1.1.
Hi Team,
We recently migrated the pipelines from v6.1.1. to V6.3 on prem.
We are reading a table from database and column has datatype - number(20,0). In CDAP wrangler, its datatype is bigdecimal and when we try to convert it to long and run the pipeline, we are receiving the following exception:
Schema field 'column' has type decimal with precision 38 and scale 0 but in input record found type decimal with precision 20 and scale 0
Problem converting into output record. Reason : Schema specifies field 'ID' is long, but the value is nor a string or long. It is of type 'BigDecimal',0,Wrangler_CIM_GENERIC
[B@5513982,[B@22351330,[B@2158d1d1,1614553200000000,I,[B@72238cf0,[B@7e32261f,Nem járulok hozzá,,[B@7414167a,A,Problem converting into output record. Reason : Schema specifies field 'ID' is long, but the value is nor a string or long. It is of type 'BigDecimal',0,Wrangler_CIM_GENERIC
Because of this datatype issue, all records from input are going to error.
Same pipeline is working as expected in CDAP V6.1.1.