cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nico Haller (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-11485) ArithmeticException in avgFunctionForDecimal
Date Mon, 04 Apr 2016 13:58:25 GMT

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

Nico Haller commented on CASSANDRA-11485:
-----------------------------------------

Sorry, forgot the actual server log:

java.lang.ArithmeticException: Non-terminating decimal expansion; no exact representable decimal
result.
        at java.math.BigDecimal.divide(BigDecimal.java:1690) ~[na:1.8.0_74]
        at org.apache.cassandra.cql3.functions.AggregateFcts$3$1.compute(AggregateFcts.java:184)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.selection.AggregateFunctionSelector.getOutput(AggregateFunctionSelector.java:52)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.selection.Selection$SelectionWithProcessing$1.getOutputRow(Selection.java:556)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.selection.Selection$ResultSetBuilder.getOutputRow(Selection.java:369)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.selection.Selection$ResultSetBuilder.build(Selection.java:357)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.statements.SelectStatement.pageAggregateQuery(SelectStatement.java:379)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:330)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:214)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:76)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:206)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:237) ~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222) ~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:115)
~[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:507)
[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:401)
[apache-cassandra-3.3.jar:3.3]
        at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
        at io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:32)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
        at io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:324)
[netty-all-4.0.23.Final.jar:4.0.23.Final]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_74]
        at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:164)
[apache-cassandra-3.3.jar:3.3]
        at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [apache-cassandra-3.3.jar:3.3]
        at java.lang.Thread.run(Thread.java:745) [na:1.8.0_74]

> ArithmeticException in avgFunctionForDecimal
> --------------------------------------------
>
>                 Key: CASSANDRA-11485
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11485
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>            Reporter: Nico Haller
>            Priority: Minor
>
> I am running into issues when using avg in queries on decimal values.
> It throws an ArithmeticException in org/apache/cassandra/cql3/functions/AggregateFcts.java
(Line 184).
> So whenever an exact representation of the quotient is not possible it will throw that
error and it never returns to the querying client.
> I am not so sure if this is intended behavior or a bug, but in my opinion if an exact
representation of the value is not possible, it should automatically round the value.
> Specifying a rounding mode when calling the divide function should solve the issue



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message