[
https://issues.apache.org/jira/browse/TAJO-746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13970502#comment-13970502
]
Hudson commented on TAJO-746:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #174 (See
[https://builds.apache.org/job/Tajo-master-build/174/])
TAJO-746: Implements function COALESCE. (hyoungjunkim via hyunsik) (hyunsik:
rev 014f9f3ef32b944f901ec97e60f1cec0a7cb2ac1)
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/function/builtin/CoalesceString.java
* tajo-client/src/main/java/org/apache/tajo/jdbc/TajoResultSetBase.java
*
tajo-catalog/tajo-catalog-server/src/main/java/org/apache/tajo/catalog/CatalogServer.java
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/function/builtin/Coalesce.java
* tajo-client/src/main/java/org/apache/tajo/client/ResultSetUtil.java
*
tajo-catalog/tajo-catalog-common/src/main/java/org/apache/tajo/catalog/CatalogUtil.java
*
tajo-core/tajo-core-backend/src/test/java/org/apache/tajo/engine/function/TestConditionalExpressions.java
* CHANGES.txt
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/function/builtin/CoalesceLong.java
*
tajo-catalog/tajo-catalog-server/src/test/java/org/apache/tajo/catalog/TestCatalog.java
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/parser/HiveQLAnalyzer.java
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/parser/SQLAnalyzer.java
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/planner/ExprsVerifier.java
*
tajo-catalog/tajo-catalog-common/src/test/java/org/apache/tajo/catalog/TestCatalogUtil.java
* tajo-common/src/main/proto/DataTypes.proto
*
tajo-core/tajo-core-backend/src/main/java/org/apache/tajo/engine/function/builtin/CoalesceDouble.java
> Implements function COALESCE
> ----------------------------
>
> Key: TAJO-746
> URL: https://issues.apache.org/jira/browse/TAJO-746
> Project: Tajo
> Issue Type: New Feature
> Reporter: hyoungjunkim
> Assignee: hyoungjunkim
> Attachments: TAJO-746.patch, TAJO-746_2.patch
>
>
> See title.
> The next description is from the postgresql
> document(http://www.postgresql.org/docs/9.1/static/functions-conditional.html).
>
> {noformat}
> COALESCE(value [, ...])
> {noformat}
> The COALESCE function returns the first of its arguments that is not null.
> Null is returned only if all arguments are null. It is often used to
> substitute a default value for null values when data is retrieved for
> display, for example:
> {code:sql}
> SELECT COALESCE(description, short_description, '(none)') ...
> {code}
> Like a CASE expression, COALESCE only evaluates the arguments that are needed
> to determine the result; that is, arguments to the right of the first
> non-null argument are not evaluated. This SQL-standard function provides
> capabilities similar to NVL and IFNULL, which are used in some other database
> systems.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
