SAP Knowledge Base Article - Preview

3428356 - Snowflake column with DECIMAL(X, 0) data type is mapped to INTEGER or BIGINT in the virtual table - SAP HANA Smart Data Integration

Symptom

  • Camel adapter is turning a long decimal number type such as DECIMAL(33,0) into a HANA BIGINT, even though this decimal has far greater precision than HANA's BIGINT can handle.
  • Decimal fields in Snowflake are accurately represented if their scale is not zero.
  • framework_alert.trc shows a NumberFormatException while reading data from such a table, if the column value exceeds the corresponding HANA Integer:
    • DefaultErrorHandler | CamelLogger.log [] - Failed delivery for (MessageId: ... on ExchangeId: ...). Exhausted after delivery attempt: 1 caught: java.lang.NumberFormatException: For input string: "120398712309487123098"


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.