[PHOENIX-3210] Exception trying to cast Double to BigDecimal in UpsertCompiler

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 4.7.0
• Fix Version/s: 4.9.0, 4.8.1
• Labels: SFDC
• Assignee: prakul agarwal
• Reporter: Shehzaad Nakhoda
• Created: 25/Aug/16 21:22
• Updated: 28/Sep/16 05:15
• Resolved: 10/Sep/16 19:57

Description

We have an UPSERT statement that is resulting in this stack trace. Unfortunately I can't get a hold of the actual Upsert statement since we don't log it.

Cause0: java.lang.ClassCastException: java.lang.Double cannot be cast to java.math.BigDecimal
Cause0-StackTrace:
at org.apache.phoenix.schema.types.PDecimal.isSizeCompatible(PDecimal.java:312)
at org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:887)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:335)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:323)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:321)
at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1274)
at phoenix.connection.ProtectedPhoenixStatement.executeUpdate(ProtectedPhoenixStatement.java:127)

Issue Links

• is related to: PHOENIX-2983 ClassCastException on auto coerce of BIGINT to DECIMAL