You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2015/01/20 05:41:34 UTC

[jira] [Updated] (PHOENIX-1594) Using KeyOnlyFilter for simple query of select count(1) from 
     [ https://issues.apache.org/jira/browse/PHOENIX-1594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-1594:
----------------------------------
    Summary: Using KeyOnlyFilter for simple query of select count(1) from <table>  (was: Using KeyOnlyFilter for simple query "select count(1) from <table>")

> Using KeyOnlyFilter for simple query of 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
>         Attachments: PHOENIX-1594.patch
>
>
> 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)