phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Jha (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4043) NumberFormatException on adding expressions containing division by zeros
Date Thu, 20 Jul 2017 10:48:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-4043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16094513#comment-16094513
] 

Aman Jha commented on PHOENIX-4043:
-----------------------------------

[~samarthjain] is any work-around available for this scenario?

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

Mime
View raw message