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]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA512 > > 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 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG/MacGPG2 v2.0.22 (Darwin) > Comment: GPGTools - https://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iQEcBAEBCgAGBQJTDHfcAAoJEE8qSVxLG/CLhVoIAJVFdonQ05ifncXJ1ElC/gUt > kmf4YXk4kdE5LBX9Dc2QqPHqZ+V/+b1fmjonmUgICi5fRtXpXGMH0jyI+jurwUwD > Wy2sy5QV7qX2/IwpuVwKfQzqaNlk6Ph/bTmO2fo1g7LCxftWL69DN1NtOU1doU5w > 4fs9Zby7evQUQ7WbaefIwHyi4uvMR4KAu2jpnnskzrSXlepIkYvxbSToMLkshTzn > s9G3uIc/uZzmZvLnSGd9RoV8kstS1Bs+Kgw/QViBwZV7keWgxEsdZGsHfA0C/nSB > A6kMpxdPeyM3kn1Bq7FnaQwg+RxryDyk3KqO1w7X0CeI9BxMWvQaZ622+qFF2ZE= > =bL5M > -----END PGP SIGNATURE----- >
