Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Run SQL on CSV, Parquet, JSON, Arrow, Unix Pipes and Google Sheet. Parent comment
A simple group by
time columnq sql --table books_10m.ndjson "SELECT AVG(overall) FROM books_10m"
The equivalent in OctoSQL takes less than 3 seconds.
I retract my statement about this project being blazingly fast, though I imagine it's just the JSON parser that requires optimization.
There are no comments on this comment yet.
A simple group by
takes 66 seconds.The equivalent in OctoSQL takes less than 3 seconds.
I retract my statement about this project being blazingly fast, though I imagine it's just the JSON parser that requires optimization.