[PHOENIX-178] slow query

• Type: Task
• Status: Resolved
• Resolution: Fixed
• Labels: duplicate
• old issue number: 47
• Assignee: Unassigned
• Reporter: ryang-sfdc
• Created: 10/Mar/14 23:46
• Updated: 16/Mar/14 07:18
• Resolved: 16/Mar/14 07:18

Description

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.