[ 
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)

Reply via email to