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] [Updated] (PHOENIX-4043) NumberFormatException on adding expressions containing division by zeros
Date Thu, 20 Jul 2017 10:44:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-4043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Aman Jha updated PHOENIX-4043:
------------------------------
    Description: 
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

  was:
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}



> 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.8.1
>         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