Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
MIME-Version: 1.0
In-Reply-To: <CANJ3crWgDyDrQra--Z=3=vwUqWJ7+7G0K82K3UF3h4AAzxhOGg@mail.gmail.com>
References: <CANJ3crWgDyDrQra--Z=3=vwUqWJ7+7G0K82K3UF3h4AAzxhOGg@mail.gmail.com>
From: DuyHai Doan <doanduyhai@gmail.com>
Date: Mon, 3 Jul 2017 23:16:33 +0200
Message-ID: <CABNXB2Bab79wfB+gLMrodS+KVJkN4mBiW6K-7K01mpZxs66p_Q@mail.gmail.com>
Subject: Re: UDF for sorting
To: user <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary="94eb2c14949a458add055370497e"
archived-at: Mon, 03 Jul 2017 21:17:04 -0000

--94eb2c14949a458add055370497e
Content-Type: text/plain; charset="UTF-8"

Plain answer is no you can't

The reason is that UDF only transform column values on each row but does
not have the ability to modify rows ordering

On Mon, Jul 3, 2017 at 10:14 PM, techpyaasa . <techpyaasa@gmail.com> wrote:

> Hi all,
>
> I have a table like
>
> CREATE TABLE ks.cf ( pk1 bigint, cc1 bigint, disp_name text , stat_obj
> text, status int, PRIMARY KEY (pk1, cc1)) WITH CLUSTERING ORDER BY (cc1 ASC)
>
> CREATE INDEX idx1 on ks.cf(status);
>
> I want to have a queries like
> *select * from ks.cf <http://ks.cf> where pk1=123 and cc1=345;*
>
> and
> *select * from ks.cf <http://ks.cf> where pk1=123 and status=1;*
> In this case , I want rows to be sorted based on 'disp_name' (asc/desc) .
>
> Can I achieve the same using UDF or anything else ?? (Sorry If my
> understanding about UDF is wrong).
>
> Thanks in advance
> TechPyaasa
>

--94eb2c14949a458add055370497e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Plain answer is no you can&#39;t<div><br></div><div>The re=
ason is that UDF only transform column values on each row but does not have=
 the ability to modify rows ordering</div></div><div class=3D"gmail_extra">=
<br><div class=3D"gmail_quote">On Mon, Jul 3, 2017 at 10:14 PM, techpyaasa =
. <span dir=3D"ltr">&lt;<a href=3D"mailto:techpyaasa@gmail.com" target=3D"_=
blank">techpyaasa@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div dir=3D"ltr">Hi all,<div><br></div><div>I have a table like=C2=
=A0</div><div><br></div><div>CREATE TABLE <a href=3D"http://ks.cf" target=
=3D"_blank">ks.cf</a> ( pk1 bigint, cc1 bigint, disp_name text , stat_obj t=
ext, status int, PRIMARY KEY (pk1, cc1)) WITH CLUSTERING ORDER BY (cc1 ASC)=
<br></div><div><br></div><div>CREATE INDEX idx1 on <a href=3D"http://ks.cf"=
 target=3D"_blank">ks.cf</a>(status);<br><br>I want to have a queries like=
=C2=A0<br><i>select * from <a href=3D"http://ks.cf" target=3D"_blank">ks.cf=
</a> where pk1=3D123 and cc1=3D345;</i></div><div><br></div><div>and=C2=A0<=
br><i>select * from <a href=3D"http://ks.cf" target=3D"_blank">ks.cf</a> wh=
ere pk1=3D123 and status=3D1;</i></div><div>In this case , I want rows to b=
e sorted based on &#39;disp_name&#39; (asc/desc) .<br><br>Can I achieve the=
 same using UDF or anything else ?? (Sorry If my understanding about UDF is=
 wrong).<br><br>Thanks in advance<span class=3D"HOEnZb"><font color=3D"#888=
888"><br>TechPyaasa=C2=A0</font></span></div></div>
</blockquote></div><br></div>

--94eb2c14949a458add055370497e--