Presto equivalent of MySQL group_concat
Try using this in place of group_concat in Presto :: select a, array_join(array_agg(b), ‘,’) from table group by a
trino
Presto/Trino – static date and timestamp in where clause
Unlike some other databases, Trino doesn’t automatically convert between varchar and other types, even for constants. The cast works, but a simpler way is to use the type constructors: WHERE segment=”2557172″ AND date = date ‘2016-06-23’ AND count_time BETWEEN timestamp ‘2016-06-23 14:00:00.000’ AND timestamp ‘2016-06-23 14:59:59.000’ You can see examples for various types here: https://trino.io/docs/current/language/types.html