Decimal Precision error

sai_sathya — Tue, 20 Feb 2024 18:49:48 GMT

when i try to create an dataframe like this

lstOfRange = list() lstOfRange = [ ['CREDIT_LIMIT_RANGE',Decimal(10000000.010000),Decimal(100000000000000000000000.000000),'>10,000,000','G'] ] RangeSchema = StructType([StructField("rangeType",StringType(),True), StructField("rangeFrom",DecimalType(32,6),True), StructField("rangeTo",DecimalType(32,6),True), StructField("rangeName",StringType(),True), StructField("rangeOrder",StringType(),True)]) df = spark.createDataFrame(data = lstOfRange, schema = RangeSchema)

and when i try to display df in rangeTo column iam getting this value 99999999999999991611392.000000

even if i try to print it is the same

print(Decimal(100000000000000000000000.000000))

output : 99999999999999991611392

topic Decimal Precision error in Get Started Discussions

Decimal Precision error