[ 
https://issues.apache.org/jira/browse/PHOENIX-1312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

James Taylor updated PHOENIX-1312:
----------------------------------
    Attachment: PHOENIX-1312_v2.patch

Try this patch as a start, [~ram_krish]. Here's an example of where the first 
column family (i.e. the one that contains the empty key value) doesn't need to 
be projected (and thus the stats for column family B should be used instead):
{code}
CREATE TABLE T (
    k INTEGER PRIMARY KEY, 
    A.V1 VARCHAR, 
    B.V2 VARCHAR);
SELECT B.V2 FROM T WHERE B.V2 = 'a'
{code}

> Do not always project the empty column family
> ---------------------------------------------
>
>                 Key: PHOENIX-1312
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1312
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Assignee: ramkrishna.s.vasudevan
>             Fix For: 4.7.0
>
>         Attachments: PHOENIX-1312_1.patch, PHOENIX-1312_v2.patch, 
> Phoenix-1312.patch
>
>
> Often times, we don't need to, but it seems we always are. See 
> MultiCfQueryExecIT.testGuidePostsForMultiCFs() where we run a query like this:
> {code}
> SELECT count(*) FROM multi_cf WHERE e.cpu_utilization IS NOT NULL
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to