You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Gabriel Reid (JIRA)" <ji...@apache.org> on 2014/03/16 08:20:13 UTC

[jira] [Resolved] (PHOENIX-178) slow query

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

Gabriel Reid resolved PHOENIX-178.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> slow query
> ----------
>
>                 Key: PHOENIX-178
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-178
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: ryang-sfdc
>              Labels: duplicate
>
> SELECT max(val) FROM mytable WHERE date >= TO_DATE(?) AND date <= TO_DATE(?) AND host LIKE 'baz-%' AND host NOT LIKE '%foobar%' GROUP BY ROUND(date,'minute',?)
> Row key is composed of a non-nullable host followed by a date.



--
This message was sent by Atlassian JIRA
(v6.2#6252)