[ https://issues.apache.org/jira/browse/DRILL-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518410#comment-14518410 ]
Victoria Markman commented on DRILL-2215: ----------------------------------------- Verified fixed. > COALESCE function needs to be documented > ---------------------------------------- > > Key: DRILL-2215 > URL: https://issues.apache.org/jira/browse/DRILL-2215 > Project: Apache Drill > Issue Type: Bug > Components: Documentation > Affects Versions: 0.8.0 > Reporter: Victoria Markman > Assignee: Kristine Hahn > > COALESCE function returns the first non-null expression in the list. If all > expressions evaluate to null, then the COALESCE function will return null. > COALESCE( expr1, expr2, ... expr_n ) > expr1 to expr_n are the expressions to test for non-null values. > Expressions have to be of the same type. -- This message was sent by Atlassian JIRA (v6.3.4#6332)