Fwd: Issues w/ count (distinct col) queries via phoenix table with secondary indexes

2015-04-28 Thread Jude K
Hi, Yesterday, we created a secondary index on one our tables to help improve the read speed of performing select count queries like the one below. The query w/ index runs fast but provides the same counts. The query w/o index (/*+ NO_INDEX */) runs slower but provides the right counts for each

Issues w/ count (distinct col) queries via phoenix table with secondary indexes

2015-04-28 Thread Jude K
Yesterday, we created a secondary index on one our tables to help improve the read speed of performing select count queries like the one below. The query w/ index runs fast but provides the same counts. The query w/o index (/*+ NO_INDEX */) runs slower but provides the right counts for each

Re: Phoenix Index Disabled

2015-03-01 Thread Jude K
, is supported since 4.2 From: Jude K j2k...@gmail.com Reply-To: user@phoenix.apache.org user@phoenix.apache.org Date: Saturday, February 28, 2015 at 7:07 PM To: user@phoenix.apache.org user@phoenix.apache.org Subject: Phoenix Index Disabled Hi, Been stuck on this issue for few hours

Phoenix Index Disabled

2015-02-28 Thread Jude K
Hi, Been stuck on this issue for few hours. Hoping someone can shed some light. OS: Centos-6 Phoenix Client: phoenix-4.0.0.2.1.5.0-695-client.jar Phoenix Core: phoenix-core-4.0.0.2.1.5.0-695.jar Hbase Version: Version 0.98.0.2.1.5.0-695-hadoop2, 6 RS Hbase RS Java Heap : 6 Gb So, 1) Created a