From PostgreSQL to Cassandra - Aggregation functions not supported

0
votes

I need your advise please. I have an application that runs on PostgreSQL but takes too long to bring back data. I would like to use Cassandra but noticed that CQL does not support aggregation. Would that be possible with Hadoop or am I going completely the wrong way? Also all the dates are stored in Epoch, and CQL can't convert them.

What would be the best approach to convert an application that runs on PostGreSQL to Cassandra?

Thank you for any suggestions.

1
postgresqlhadoopcassandradatastaxnosql-aggregation

1 Answers

4
votes

Cassandra introduced aggregate functions in 2.2 with CASSANDRA-4914. The documentation for using the standard (built in) functions is here and for creating custom aggregate functions is here.