Size: a a a
PC
PC
insert into entity_events values ('2020-09-20 00:00:01', 1, 'a', 'a', 'a');
insert into entity_events values ('2020-09-20 00:00:00', 1, 'a', 'a', 'a');
insert into entity_events values ('2020-09-20 00:00:02', 2, 'a', 'a', 'a');
insert into entity_events values ('2020-09-20 00:00:01', 3, 'a', 'a', 'a');PC
PC
ДБ
max((datetime,event)) я что - то совсем не понялpk
PC
T🐜
pk
T🐜
pk
pk
T🐜
select foo from bar where x ='baz';
select sum(foo) from bar group by x
baz. вот это посчитано не точно.pk
T🐜
T🐜
DC
select foo from bar where x ='baz';
select sum(foo) from bar group by x
baz. вот это посчитано не точно.select toString(foo) from bar where x ='baz';PC
SELECT id, any(unique_events) as events FROM (
SELECT
any(id) as id,
groupArrayMerge(events) AS groupedEvents,
-- Sort array by datetime
arraySort((x, y) -> tupleElement(y, 2) - tupleElement(x, 2), groupedEvents, arrayReverse(groupedEvents)) as sorted,
arrayMap(x -> tupleElement(x, 1), sorted) as event_types_map,
-- Distinct array indexes by event
arrayDistinct(arrayEnumerateDense(event_types_map)) as event_types_map_dense,
arrayMap(x -> sorted[x], event_types_map_dense) as unique_events
FROM entity_events_trace
) GROUP BY id;
НБ
timestamp DateTime,user_id String,group_id String,latitude Float32,longitude Float32,state String,place_id String,accuracy Float32,DC
timestamp DateTime,user_id String,group_id String,latitude Float32,longitude Float32,state String,place_id String,accuracy Float32,