[jira] [Resolved] (PHOENIX-241) sum() and avg() does not support UNSIGNED_INT and UNSIGNED_LONG

["Gabriel Reid (JIRA)" <ji...@apache.org>]

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

Gabriel Reid resolved PHOENIX-241.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> sum() and avg() does not support UNSIGNED_INT and UNSIGNED_LONG
> ---------------------------------------------------------------
>
>                 Key: PHOENIX-241
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-241
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: Raymond Liu
>
> Well, I can understand that it do not support UNSIGNED_LONG, But it don't support UNSIGNED_INT make it not very useful. Especially a VIEW on an existing HBase table which write Bytes.toBytes(int) to column
> The following logs taken from avg() on a UNSIGNED_INT field.
> Caused by: org.apache.hadoop.ipc.RemoteException: org.apache.hadoop.hbase.DoNotRetryIOException: 1kint,,1363939671453.4c0a1ca3c82321ceea9075283d6cdf3e.: Unsupported SUM input type: LONG
>         at com.salesforce.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:49)
>         at com.salesforce.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:61)
>         at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1260)
>         at org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2399)
>         at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:601)
>         at org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320)
>         at org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1426)
> Caused by: java.lang.IllegalStateException: Unsupported SUM input type: LONG
>         at com.salesforce.phoenix.expression.function.SumAggregateFunction.newServerAggregator(SumAggregateFunction.java:79)
>         at com.salesforce.phoenix.expression.function.SingleAggregateFunction.readFields(SingleAggregateFunction.java:149)
>         at com.salesforce.phoenix.expression.aggregator.ServerAggregators.deserialize(ServerAggregators.java:127)
>         at com.salesforce.phoenix.coprocessor.UngroupedAggregateRegionObserver.doPostScannerOpen(UngroupedAggregateRegionObserver.java:126)
>         at com.salesforce.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:59)
>         ... 7 more



--
This message was sent by Atlassian JIRA
(v6.2#6252)