[ 
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` 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.


  was:
Tajo shows users function list in two places(CLI,Web) in only alphabetical 
`function name` 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             | 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 set 
of numbers                   | AGGREGATIO
 sum             | FLOAT8          | float8                | the sum of a set 
of numbers                   | AGGREGATIO
 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
 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
{code}

Please note that the 'Result Type', 'Argument Type' is sorted by size. 
`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
>
>
> Tajo shows users function list in two places(CLI,Web) in only alphabetical 
> `function name` 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.



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

Reply via email to