[ https://issues.apache.org/jira/browse/PHOENIX-4043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aman Jha updated PHOENIX-4043: ------------------------------ Affects Version/s: 4.9.0 4.10.0 4.11.0 > NumberFormatException on adding expressions containing division by zeros > ------------------------------------------------------------------------ > > Key: PHOENIX-4043 > URL: https://issues.apache.org/jira/browse/PHOENIX-4043 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.9.0, 4.8.1, 4.10.0, 4.11.0 > Environment: OS : Linux (Server) , Windows(SquirrelSQL Client) > Hbase: 1.2.4 > Reporter: Aman Jha > > When two columns containing zero values are divided and added to another > expression, number format exception is raised on server and the client shows > no error(times out after a certain interval) > The following stack trace is generated on server : > {code:java} > java.lang.NumberFormatException > at java.math.BigDecimal.<init>(BigDecimal.java:494) > at java.math.BigDecimal.<init>(BigDecimal.java:383) > at java.math.BigDecimal.<init>(BigDecimal.java:806) > at java.math.BigDecimal.valueOf(BigDecimal.java:1274) > at > org.apache.phoenix.schema.types.PDecimal.toObject(PDecimal.java:139) > at > org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:991) > at > org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1003) > at > org.apache.phoenix.expression.DecimalAddExpression.evaluate(DecimalAddExpression.java:65) > at > org.apache.phoenix.expression.DecimalSubtractExpression.evaluate(DecimalSubtractExpression.java:64) > at > org.apache.phoenix.expression.aggregator.ServerAggregators.aggregate(ServerAggregators.java:59) > at > org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:618) > at > org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.overrideDelegate(BaseScannerRegionObserver.java:214) > at > org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScannerHolder.nextRaw(BaseScannerRegionObserver.java:259) > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.java:2563) > at > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2180) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at > org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133) > at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108) > at java.lang.Thread.run(Thread.java:745) > {code} > The error occurs due to conversion of Double.NaN to BigDecimal -- This message was sent by Atlassian JIRA (v6.4.14#64029)