Skip to site navigation (Press enter)

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

James Taylor (JIRA) Tue, 10 Feb 2015 10:38:34 -0800

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

James Taylor reassigned PHOENIX-1594:
-------------------------------------

    Assignee: James Taylor

> 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
>            Assignee: James Taylor
>         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)
  • Previous message
  • View by thread
  • View by date
  • Next message

Reply via email to

The Mail Archive
  • The Mail Archive home
  • dev - all messages
  • dev - about the list
  • Expand
  • Previous message
  • Next message
  • The Mail Archive home
  • Add your mailing list
  • FAQ
  • Support
  • Privacy
  • [email protected]