ListDistinctVariant.sql 367 B

1234567891011
  1. /* syntax version 1 */
  2. $vt1 = Variant<Int32,String>;
  3. select AGGREGATE_LIST_DISTINCT(x) from
  4. (select [Variant(1,"0",$vt1),Variant("str","1",$vt1),Variant(1,"0",$vt1)] as x)
  5. flatten list by x;
  6. $vt2 = Variant<x:Int32,y:String>;
  7. select AGGREGATE_LIST_DISTINCT(x) from
  8. (select [Variant(1,"x",$vt2),Variant("str","y",$vt2),Variant(1,"x",$vt2)] as x)
  9. flatten list by x;