Skip to main content

Any thoughts on the below error, trying to load data into a Hive table that has columns defined as decimal 11,2

Value is 6500, I have also tried stringformatter to 11.2f, and hard coding value to 6500.00, and a few other things like setting the value to double(@Value(my_amount), etc.

 

 

Database Error Message: :Cloudera]aImpalaODBC] (370) Query analysis error occurred during query execution: :HY000] : AnalysisException: Possible loss of precision for target table 'xxx.xxxx'.

 

Expression 'CAST(65000 AS DOUBLE)' (type: DOUBLE) would need to be cast to DECIMAL(11,2) for column 'my_amount'

Be the first to reply!

Reply