I'm searching for any NoSQL
system (preferably open source) that supports analytic functions (AF
for short) like Oracle/SQL Server/Postgres does. I didn't find any with build-in functions. I've read something about Hive
but it doesn't have actual feature of AF
(windows, first_last values, ntiles, lag, lead and so on) just histograms and ngrams. Also some NoSQL systems (Redis
for example) support map/reduce, but I'm not sure if AF
can be replaced with it.
I want to make a performance comparison to choose either Postgres or NoSQL system.
So, in short:
- Searching for
NoSQL
systems withAF
- Can I rely on map/reduce to replace
AF
? Is it fast, reliable, easy to go.
ps. I tried to make my question more constructive.