Re:Re: Skip scan optimization failed for multi pk columns

2016-09-24 Thread William
Ted: The email in my 'send box' has the attachment, but the email received didn't. I don't why. I filed a jira, see https://issues.apache.org/jira/browse/PHOENIX-3328. I only add one test case for this. We already have some UT and IT for other scenarios that WHERE clause shouldn't be optimized

Re:Re: Skip scan optimization failed for multi pk columns

2016-09-24 Thread William
OK James, I'll do this tomorrow and have a look at those tickets. Also, I am planning to do this, https://issues.apache.org/jira/browse/PHOENIX-1801. I'd like to support intersect and union scenario first, then sort union. Actually the QueryOptimizer doesn't 'choose' the appropriate index