yes thanks for your help
Maarten Verstuurd vanaf mijn iPhone Op 25 feb. 2014 om 19:55 heeft "James Taylor" <[email protected]<mailto:[email protected]>> het volgende geschreven: Ok, just to confirm, it's working correctly now? Thanks, James On Tue, Feb 25, 2014 at 10:36 AM, Maarten Wullink <[email protected]<mailto:[email protected]>> wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 I dit remove the old jar and did a restart. But i probably did not execute the DDL again. Sometimer later i did drop and recreate the database table and then the error went away. this is de exception log from the RS 2014-02-25 02:53:33,609 ERROR org.apache.hadoop.hbase.regionserver.HRegionServer: Failed openScanner org.apache.hadoop.hbase.DoNotRetryIOException: queries,\x03\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00,1393325069607.00765ac94869a13fec1e76ca80b62f92.: com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:73) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:51) at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost.postScannerOpen(RegionCoprocessorHost.java:1313) at org.apache.hadoop.hbase.regionserver.HRegionServer.openScanner(HRegionServer.java:2429) at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.hbase.ipc.WritableRpcEngine$Server.call(WritableRpcEngine.java:320) at org.apache.hadoop.hbase.ipc.HBaseServer$Handler.run(HBaseServer.java:1428) Caused by: java.lang.NoSuchMethodError: com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z at org.apache.phoenix.cache.aggcache.SpillMap$MappedByteBufferMap.addElement(SpillMap.java:437) at org.apache.phoenix.cache.aggcache.SpillMap.put(SpillMap.java:294) at org.apache.phoenix.cache.aggcache.SpillManager.spill(SpillManager.java:261) at org.apache.phoenix.cache.aggcache.SpillableGroupByCache$1.removeEldestEntry(SpillableGroupByCache.java:190) at java.util.LinkedHashMap.addEntry(LinkedHashMap.java:410) at java.util.HashMap.put(HashMap.java:385) at org.apache.phoenix.cache.aggcache.SpillableGroupByCache.cache(SpillableGroupByCache.java:251) at org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.scanUnordered(GroupedAggregateRegionObserver.java:384) at org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver.doPostScannerOpen(GroupedAggregateRegionObserver.java:131) at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:49) ... 7 more James Taylor schreef op 25-02-14 18:01: > One thing I forgot to mention: please make sure to remove the old > Phoenix jar, bounce your cluster and rerun your DDL statement, as > there's no code in place to upgrade the schema. > > If you've already done that, would you mind checking the server log > for exceptions? > > Thanks, James > > On Tuesday, February 25, 2014, Maarten Wullink > <[email protected]<mailto:[email protected]>> wrote: > > I am getting an exception when trying to do aggregation. > > I am using: phoenix master branch (3.0) hbase CDH4 0.94.6+165 > > > 0: jdbc:phoenix:192.168.129.208> select rname, count(*) as qt > from "queries" group by rname order by qt desc limit 10; > +------------+----------+ | RNAME | QT | > +------------+----------+ java.lang.RuntimeException: > org.apache.phoenix.exception.PhoenixIOException: > org.apache.phoenix.exception.PhoenixIOException: > org.apache.hadoop.hbase.DoNotRetryIOException: > queries,,1393325069606.ebd900b0b184cfd79db278e63e139965.: > com.google.common.hash.BloomFilter.put(Ljava/lang/Object;)Z at > sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) at > sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) at > sqlline.SqlLine.print(SqlLine.java:1735) at > sqlline.SqlLine$Commands.execute(SqlLine.java:3683) at > sqlline.SqlLine$Commands.sql(SqlLine.java:3584) at > sqlline.SqlLine.dispatch(SqlLine.java:821) at > sqlline.SqlLine.begin(SqlLine.java:699) at > sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) at > sqlline.SqlLine.main(SqlLine.java:424) > > > > Is this a known issue? > > > Cheers, > > Maarten >> > - -- Maarten Wullink | Research Engineer SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM T +31 (0)26 352 55 45<tel:%2B31%20%280%2926%20352%2055%2045> | M +31 (0)6 21 26 87 55<tel:%2B31%20%280%296%2021%2026%2087%2055> | F +31 (0)26 352 55 05<tel:%2B31%20%280%2926%20352%2055%2005> [email protected]<mailto:[email protected]> | www.sidn.nl<http://www.sidn.nl> -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.22 (Darwin) Comment: GPGTools - https://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBCgAGBQJTDOKmAAoJEE8qSVxLG/CLRn4H/3/U7MS2ylsCY7DwBt1Pp8oQ coEiLhwEfWgJmFjCtnLI8ZK6talJ8u/c447UkmgeXdYpnUOJvaMqNePJHfkVdFG8 5xpqjN4R3IhknxQO7vHSxghgdalnnFyaWL5P3gE2e1Iqk5Og6He3/qWJVauBDdjS YEKhvJ1KdFWnISgRkhOenAyuGRLJp16DfdaYUTq6+Lm0VLjNGJUb/3Ob8HLVVu7n fpxMwLx4wfMZto6EdzeWNcTl+hILlq/ibqy7gWlXAPAqRiSDOoy68hqG3eTDQ2xY 1bbyKGralnNlBf//tAtIboWXuB0yt54sFstmjLT0gsbKIIcdrgVsr1SfzRM4VJI= =G3qJ -----END PGP SIGNATURE-----
