[jira] [Commented] (PHOENIX-1594) Using KeyOnlyFilter for simple query "select count(1) from "

Fri, 16 Jan 2015 22:49:38 -0800

    [ 
https://issues.apache.org/jira/browse/PHOENIX-1594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14281239#comment-14281239
 ] 

James Taylor commented on PHOENIX-1594:
---------------------------------------

When there are multiple CFs, instead of projecting each one of them and having 
a FirstKeyOnlyFilter, we project only the empty KV (as we'll only look at one 
store file instead of potentially multiple ones). Is this not what's happening?

> Using KeyOnlyFilter for simple query "select count(1) from <table>"
> -------------------------------------------------------------------
>
>                 Key: PHOENIX-1594
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1594
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Jeffrey Zhong
>
> I found that underlying scan for query "select count(1) or count(*) from 
> <table>" still project all columns. 
> It should be fast if we use KeyOnlyFilter for this simple query.



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

Reply via email to