Can you share your implementation of your ABS function? You should not need
to make any changes to ORDER BY.

Thanks,
James


On Wed, Apr 9, 2014 at 10:07 PM, Seonghwan Moon <[email protected]> wrote:

> Hello,
>
> I am a developer who implement big-data infra-system using phoenix.
>
> Our team want to make a built-in-function ABS(absolute function)
>
> We made it and it works good but not work order by clause.
>
> We can't find where is the place executing order by function.
>
> ex)
> here is the test table, table has 2 rows like below.
> create table test (a integer not null primary key, b varchar(10));
>
>       a           b
>       2           abc
>      -1          ab
>
>
> ex) select abs(a), b  from test ;
>
>        2         abc
>        1         ab
>
> works fine. good. but .....
>
> ex) select abs(a),b from test order by abs(a);
>
>         2         abc
>         1         ab
>
> not working....
>
> Question)
>
> Where is the place to execute order by expression?  in phoenix client? or
> hbase co-processor?
>
> Could you please tell me the point or class name or method name that we
> have to implement?
>
> we are working on phoenix-2.2.4 version.
>
> Please answer me.
>
> Thanks in advance.
>

Reply via email to