4 ms·
Very cool. Major props for putting this out there and accepting arbitrary queries. Couple comments / questions: - Correct that there’s no GROUP BY support? -
by twoodfin 6y ago
Very cool. Major props for putting this out there and accepting arbitrary queries.
Couple comments / questions:
- Correct that there’s no GROUP BY support?
- EXPLAIN or similar would be nice, both to get a peek at how your engine works & to anticipate whether a query is using parallel / SIMD execution and will take milliseconds vs. minutes.
- bluestreak 6y agoThank you! there is no 'GROUP BY' keyword support. Optimiser works out group by queries without it. We are planning to put a noop there, just to be nice to finger memoory. EXPLAIN would be quite boring in our case, we use a myriad of methods to make query fast. We would love to keep up the performance so that no one ever needed to be interested in query plan.
- rzzzt 6y agoCheck the example queries, one of them had aggregation and simple column selection in the same query with an "order by" clause at the end. I can't tell from the output whether there is an implicit "group by" going on over the non-aggregated columns, but eg. this query produced some results without any errors: select windDir, avg(windSpeed) from weather