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

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

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

Hey Jude, Would you mind trying with 4.3.1 release and letting us know if the issue is resolved? Thanks, James On Tue, Apr 28, 2015 at 6:07 PM, Jude K j2k...@gmail.com wrote: Hi, Yesterday, we created a secondary index on one our tables to help improve the read speed of performing select

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

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