Poor Performance of Cassandra UDF/UDA

2017-09-26 Thread Xin Jin
Hi All, I am new to the Cassandra community and thank you in advance for your kindly comments on an issue we met recently. We have found that running query with direct UDF execution is ten time more faster than the async UDF execution. The in-line comment: "Using async UDF execution is expens

Re: Cassandra: UDF

2015-08-05 Thread Robert Stupp
Suresh, tip: you can use alternative (”pg-style”) string delimiters, which can span over multiple lines and makes the CQL statement much nicer: CREATE OR REPLACE FUNCTION state_groupbyandsum ( state map, datetime text, amount text ) CALLED ON NULL INPUT RETURNS map LANGUAGE java AS $$

Cassandra: UDF

2015-08-05 Thread Suresh Mahawar
Hi, I need your help. I have a query which get top 5 records group by date (not date + time) and sum of amount. I wrote the following but it returns all the records not just top 5 records CREATE OR REPLACE FUNCTION state_groupbyandsum( state map, datetime text, amount text ) CALLED ON NULL INPUT