Decimal Precision error

sai_sathya
New Contributor III

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