[ 
https://issues.apache.org/jira/browse/TAJO-1452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dongjoon Hyun updated TAJO-1452:
--------------------------------
    Description: 
Tajo shows users function list in two places(CLI,Web) in only alphabetical 
`function name` and emunerical(not alphabetical) `result type` order. This 
issue propose to display them in full alphabetical `function name`, `type`, 
`result type', 'argument type' order.

*tsql*
{code}
default> \df sum
 Name            | Result type     | Argument types        | Description        
                           | Type      
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
 sum             | INT8            | int4                  | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | INT8            | int8                  | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | INT8            | int8                  | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | INT8            | int4                  | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | FLOAT8          | float8                | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | FLOAT8          | float4                | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | FLOAT8          | float8                | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | FLOAT8          | float4                | the sum of a set 
of numbers                   | AGGREGATIO
{code}

{code}
default> \df sum
 Name            | Result type     | Argument types        | Description        
                           | Type      
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
 sum             | float8          | float4                | the sum of a set 
of numbers                   | aggregatio
 sum             | float8          | float8                | the sum of a set 
of numbers                   | aggregatio
 sum             | int8            | int4                  | the sum of a set 
of numbers                   | aggregatio
 sum             | int8            | int8                  | the sum of a set 
of numbers                   | aggregatio
 sum             | float8          | float4                | the sum of a 
distinct and non-null values     | distinct_a
 sum             | float8          | float8                | the sum of a 
distinct and non-null values     | distinct_a
 sum             | int8            | int4                  | the sum of a 
distinct and non-null values     | distinct_a
 sum             | int8            | int8                  | the sum of a 
distinct and non-null values     | distinct_a
{code}

`http://localhost:26080/functions.jsp` will change the result in the same order.


  was:
Tajo shows users function list in two places(CLI,Web) in only alphabetical 
`function name`, `result type` order. This issue propose to display them in 
`function name`, `type`, `result type', 'argument type' order.

*tsql*
{code}
default> \df sum
 Name            | Result type     | Argument types        | Description        
                           | Type      
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
 sum             | INT8            | int4                  | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | INT8            | int8                  | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | INT8            | int8                  | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | INT8            | int4                  | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | FLOAT8          | float8                | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | FLOAT8          | float4                | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | FLOAT8          | float8                | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | FLOAT8          | float4                | the sum of a set 
of numbers                   | AGGREGATIO
{code}

{code}
default> \df sum
 Name            | Result type     | Argument types        | Description        
                           | Type      
-----------------+-----------------+-----------------------+-----------------------------------------------+-----------
 sum             | FLOAT8          | float4                | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | FLOAT8          | float8                | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | INT8            | int4                  | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | INT8            | int8                  | the sum of a set 
of numbers                   | AGGREGATIO
 sum             | FLOAT8          | float4                | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | FLOAT8          | float8                | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | INT8            | int4                  | the sum of a 
distinct and non-null values     | DISTINCT_A
 sum             | INT8            | int8                  | the sum of a 
distinct and non-null values     | DISTINCT_A
{code}

`http://localhost:26080/functions.jsp` will change the result in the same order.



> Improve function listing order
> ------------------------------
>
>                 Key: TAJO-1452
>                 URL: https://issues.apache.org/jira/browse/TAJO-1452
>             Project: Tajo
>          Issue Type: Improvement
>          Components: cli, web UI
>            Reporter: Dongjoon Hyun
>            Assignee: Dongjoon Hyun
>            Priority: Trivial
>             Fix For: 0.10.1
>
>         Attachments: TAJO-1452.Hyun.150327.0.patch.txt
>
>
> Tajo shows users function list in two places(CLI,Web) in only alphabetical 
> `function name` and emunerical(not alphabetical) `result type` order. This 
> issue propose to display them in full alphabetical `function name`, `type`, 
> `result type', 'argument type' order.
> *tsql*
> {code}
> default> \df sum
>  Name            | Result type     | Argument types        | Description      
>                              | Type      
> -----------------+-----------------+-----------------------+-----------------------------------------------+-----------
>  sum             | INT8            | int4                  | the sum of a set 
> of numbers                   | AGGREGATIO
>  sum             | INT8            | int8                  | the sum of a set 
> of numbers                   | AGGREGATIO
>  sum             | INT8            | int8                  | the sum of a 
> distinct and non-null values     | DISTINCT_A
>  sum             | INT8            | int4                  | the sum of a 
> distinct and non-null values     | DISTINCT_A
>  sum             | FLOAT8          | float8                | the sum of a 
> distinct and non-null values     | DISTINCT_A
>  sum             | FLOAT8          | float4                | the sum of a 
> distinct and non-null values     | DISTINCT_A
>  sum             | FLOAT8          | float8                | the sum of a set 
> of numbers                   | AGGREGATIO
>  sum             | FLOAT8          | float4                | the sum of a set 
> of numbers                   | AGGREGATIO
> {code}
> {code}
> default> \df sum
>  Name            | Result type     | Argument types        | Description      
>                              | Type      
> -----------------+-----------------+-----------------------+-----------------------------------------------+-----------
>  sum             | float8          | float4                | the sum of a set 
> of numbers                   | aggregatio
>  sum             | float8          | float8                | the sum of a set 
> of numbers                   | aggregatio
>  sum             | int8            | int4                  | the sum of a set 
> of numbers                   | aggregatio
>  sum             | int8            | int8                  | the sum of a set 
> of numbers                   | aggregatio
>  sum             | float8          | float4                | the sum of a 
> distinct and non-null values     | distinct_a
>  sum             | float8          | float8                | the sum of a 
> distinct and non-null values     | distinct_a
>  sum             | int8            | int4                  | the sum of a 
> distinct and non-null values     | distinct_a
>  sum             | int8            | int8                  | the sum of a 
> distinct and non-null values     | distinct_a
> {code}
> `http://localhost:26080/functions.jsp` will change the result in the same 
> order.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to