Implement subqueries

[jvshahid]

No description provided.

[jvshahid]

This was closed by accident because we just merged in the upstream raft history. Reopening

[jmorales4]

+1 for this feature

[ross-nordstrom]

+1

[Dragomir-Ivanov]

+1

[pasancario]

+1

[multilinear]

When you do this, please make it arbitrarilly recursive, rather than just adding one-level. In other words, subqueries should be allowed to have subqueries :). Limiting it to 2 levels is as silly as limiting it to 1.

[gillesdemey]

+1, here's a sentence that explains my use-case:

I want to retrieve all data points from my latency measurement that are within the 90th percentile.

SELECT ms FROM latency WHERE time > now() - 2h AND ms < (SELECT percentile(ms, 90) FROM latency)

[paul91]

+1

[salanki]

+1

[Melevir]

Does "revisit in the future" means it won't be implemented in 0.9.x?

[beckettsean]

@Melevir that is correct. The "revisit in the future" label is for features beyond the 0.9 line.

[hotsnow77]

+1
I my case I'd like to do a first aggregation with a small group time and over that another aggregation with a bigger group time

[morganda]

+1

[timgriffiths]

+1

[13h3r]

+1

[siddarth7]

+1

[coding-jj]

+1

[bedrin]

+1

[asimell]

+1

[lexmag]

Rather than +1 in comments it's way better to react 👍 under initial comment.
There are many people who have subscribed to this issue to get a notification when it will be closed (hopefully implemented), and those +1 only create unnecessary noise for everyone.