Databricks Community

flashmav1

I am using dataricks version 15.4 and getting below error whicle reading from jdbc and writing to aws S3 location: [NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION] The -12874815911431.6200000000 rounded half up from -12874815911431.6200000000 cannot b...

flashmav1

I was working in databricks pyspark code side becuase the error seems like the type issue in pyspark but the actual issue is reading the 14 interger value from source. So casting to string(in my case nvarchar) worked.

flashmav1

I am able to read it like this but unable to write to s3 locaition

Databricks Community

User Stats

User Activity

[NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION] The -12874815911431.6200000000 rounded half up from

Re: [NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION] The -12874815911431.6200000000 rounded half up

Re: [NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION] The -12874815911431.6200000000 rounded half up