Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
Date: Wed, 5 Aug 2015 15:39:16 +0530
Message-ID: 
 <CABVuQoVLR2oN34echUJzHfuPjo0XW1Xhc80QZbqBEVzqEpJdsA@mail.gmail.com>
Subject: Cassandra: UDF
From: Suresh Mahawar <suresh.mahawar@technocube.in>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a114faf8a698e05051c8d9835

--001a114faf8a698e05051c8d9835
Content-Type: text/plain; charset=UTF-8

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<text, double>,
datetime text, amount text )
CALLED ON NULL INPUT
RETURNS map<text, double>
LANGUAGE java
AS 'String date = datetime.substring(0,10); Double count = (Double)
state.get(date);  if (count == null) count = Double.parseDouble(amount);
else count = count +  Double.parseDouble(amount); state.put(date, count);
return state;' ;


CREATE OR REPLACE AGGREGATE groupbyandsum(text, text)
SFUNC state_groupbyandsum
STYPE map<text, double>
INITCOND {};

select groupbyandsum(datetime, amout) from warehouse;

Could you please help out to get just 5 records.


Thanks & Regards,
Suresh Mahawar
TechnoCube
Find Me on Linkedin <https://www.linkedin.com/pub/suresh-mahawar/2a/b9/a80>

--001a114faf8a698e05051c8d9835
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div style=3D"font-size:12.8000001907349px"><div>Hi,</div>=
<div><br></div><div>I need your help. I have a query which get top 5 record=
s group by date (not date + time) and sum of amount.</div><div><br></div><d=
iv>I wrote the following but it returns all the records not just top 5 reco=
rds</div><div><br></div><div><span style=3D"background-color:rgb(204,204,20=
4)">CREATE OR REPLACE FUNCTION state_groupbyandsum( state map&lt;text, doub=
le&gt;, datetime text, amount text )</span></div><div><span style=3D"backgr=
ound-color:rgb(204,204,204)">CALLED ON NULL INPUT</span></div><div><span st=
yle=3D"background-color:rgb(204,204,204)">RETURNS map&lt;text, double&gt;</=
span></div><div><span style=3D"background-color:rgb(204,204,204)">LANGUAGE =
java=C2=A0</span></div><div><span style=3D"background-color:rgb(204,204,204=
)">AS &#39;String date =3D datetime.substring(0,10); Double count =3D (Doub=
le) state.get(date); =C2=A0if (count =3D=3D null) count =3D Double.parseDou=
ble(amount); else count =3D count + =C2=A0Double.parseDouble(amount); state=
.put(date, count); return state;&#39; ;</span></div><div><br></div><div><br=
></div><div><span style=3D"background-color:rgb(204,204,204)">CREATE OR REP=
LACE AGGREGATE groupbyandsum(text, text)=C2=A0</span></div><div><span style=
=3D"background-color:rgb(204,204,204)">SFUNC state_groupbyandsum</span></di=
v><div><span style=3D"background-color:rgb(204,204,204)">STYPE map&lt;text,=
 double&gt;</span></div><div><span style=3D"background-color:rgb(204,204,20=
4)">INITCOND {};</span></div></div><div style=3D"font-size:12.8000001907349=
px"><br></div><div style=3D"font-size:12.8000001907349px"><span style=3D"ba=
ckground-color:rgb(204,204,204)">select groupbyandsum(datetime, amout) from=
 warehouse;</span><br></div><div style=3D"font-size:12.8000001907349px"><br=
></div><div style=3D"font-size:12.8000001907349px">Could you please help ou=
t to get just 5 records.</div><div><br></div><div><br></div><div><div class=
=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr">Thanks &amp; Re=
gards,<div>Suresh Mahawar</div><div>TechnoCube</div><div>Find Me on=C2=A0<a=
 href=3D"https://www.linkedin.com/pub/suresh-mahawar/2a/b9/a80" target=3D"_=
blank">Linkedin</a></div></div></div></div></div></div>
</div>

--001a114faf8a698e05051c8d9835--