tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TAJO-482) Implements listing functions and describing a specified function.
Date Wed, 22 Jan 2014 02:13:22 GMT

    [ https://issues.apache.org/jira/browse/TAJO-482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13878161#comment-13878161
] 

Hudson commented on TAJO-482:
-----------------------------

SUCCESS: Integrated in Tajo-master-build #24 (See [https://builds.apache.org/job/Tajo-master-build/24/])
TAJO-482: Implements listing functions and describing a specified function. (hyoungjunkim
via hyunsik) (hyunsik: https://git-wip-us.apache.org/repos/asf?p=incubator-tajo.git&a=commit&h=9a9d6eaf432f1903414792a0384b464753aa52a3)
* tajo-client/src/main/java/org/apache/tajo/cli/HelpCommand.java
* tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/client/TestTajoClient.java
* tajo-client/src/main/java/org/apache/tajo/cli/TajoShellCommand.java
* tajo-client/src/main/java/org/apache/tajo/cli/ExitCommand.java
* tajo-catalog/tajo-catalog-common/src/main/java/org/apache/tajo/catalog/FunctionDesc.java
* tajo-client/src/main/java/org/apache/tajo/client/TajoClient.java
* tajo-client/src/main/proto/TajoMasterClientProtocol.proto
* tajo-client/src/main/proto/ClientProtos.proto
* tajo-client/src/main/java/org/apache/tajo/cli/DescFunctionCommand.java
* tajo-client/src/main/java/org/apache/tajo/cli/VersionCommand.java
* tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/master/TajoMasterClientService.java
* tajo-client/src/main/java/org/apache/tajo/cli/TajoCli.java
* CHANGES.txt
* tajo-client/src/main/java/org/apache/tajo/cli/CopyrightCommand.java
* tajo-client/src/main/java/org/apache/tajo/cli/DescTableCommand.java
* tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java


> Implements listing functions and describing a specified function.
> -----------------------------------------------------------------
>
>                 Key: TAJO-482
>                 URL: https://issues.apache.org/jira/browse/TAJO-482
>             Project: Tajo
>          Issue Type: Sub-task
>          Components: function/udf
>            Reporter: hyoungjunkim
>            Assignee: hyoungjunkim
>            Priority: Minor
>             Fix For: 0.8-incubating
>
>         Attachments: TAJO-482.patch
>
>
> I propose function related commands in Tajo's shell. This command is similar to PostgreSQL
but a little different.
> - \df: list all functions
> - \df <function name>: list all functions which have a specified name(PostgreSQL
uses a pattern matching). 
> {code}
> tajo> \df
>                   List of functions
> Name | Result data type | Argument data types | Type 
> -----+------------------+---------------------+-------------
> avg  | FLOAT8           | INT8                | AGGREGATION
> sum  | INT8             | INT8                | AGGREGATION
> sum  | INT4             | INT4                | AGGREGATION
> sum  | FLOAT4           | FLOAT4              | AGGREGATION
> ...
> (80 rows)
> tajo> \df sum
>                   List of functions
> Name | Result data type | Argument data types | Type 
> -----+------------------+---------------------+-------------
> sum  | INT8             | INT8                | AGGREGATION
> sum  | INT4             | INT4                | AGGREGATION
> sum  | FLOAT4           | FLOAT4              | AGGREGATION
> (3 rows)
> Function: INT8 sum(expr INT8)
> Description: The sum of a set of numbers.
> Example: 
> > select sum(*)
> {code}
> When describing a specified function 
> if all functions have same description, prints out first function description. Otherwise
prints out all function.
> {code}
> tajo> \df to_char
>                   List of functions
>   Name  |  Result data type | Argument data types | Type 
> --------+-------------------+---------------------+-------------
> to_char | TEXT              | TIMETSTAMP, TEXT    | GENERAL
> to_char | TEXT              | INT4                | GENERAL
> (2 rows)
> Function: TEXT to_char(timestamp TIMETSTAMP, pattern TEXT)
> Description: convert time stamp to string.
> Example: 
> > select to_char(current_timestamp, 'HH12:MI:SS');
> 11:34:52
> Function: TEXT to_char(pattern INT4)
> Description: convert time stamp to string.
> Example: 
> > select to_char(25, '000');
> 025
> {code}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message