0

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.

Steve
  • 1,028
  • 7
  • 25
  • 42

1 Answers1

4

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.

mikea
  • 6,537
  • 19
  • 36
  • Thank you very much for the answer Mike. That was very helpful. I assume I will have to normalize the dates from Epoch before I add them to the table. – Steve Mar 09 '16 at 22:51