[ https://issues.apache.org/jira/browse/DRILL-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristine Hahn reassigned DRILL-2215: ------------------------------------ Assignee: Kristine Hahn (was: Bridget Bevens) > 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)