full_trivial_udf_call.sql 264 B

123456
  1. PRAGMA DisableSimpleColumns;
  2. /* postgres can not */
  3. select Input1.key, Input1.subkey, SimpleUdf::Concat(coalesce(Input1.value, ""), coalesce(Input3.value, "")) as value
  4. from plato.Input1
  5. full join plato.Input3 using (key)
  6. order by Input1.key, Input1.subkey, value;