framework/resources/Functional/functions/split/DRILL_6976_subquery_coalesce_split.sql

select coalesce(col, n_name)
from (select split(n_comment, ' ') [3] col, n_name
      from cp.`tpch/nation.parquet`
      where n_nationkey = -1
      limit 5);