Skip to content
This repository has been archived by the owner on Feb 12, 2022. It is now read-only.

slow query #47

Closed
ryang-sfdc opened this issue Feb 13, 2013 · 1 comment
Closed

slow query #47

ryang-sfdc opened this issue Feb 13, 2013 · 1 comment

Comments

@ryang-sfdc
Copy link
Contributor

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.

@jtaylor-sfdc
Copy link
Contributor

This query will perform better once we gather and use stats to guide parallelization (#49). I'm going to mark it as a dup of that one, but we can reopen if performance is still sub optimal after that.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants