Size: a a a
DT
OG
DT
OG
DT
WITH
groupArray(eventType) AS event_arr,
groupArray(EventTime) AS time_arr
SELECT
userID,
arrayFirst((x, y, z) -> ((y = 'A') AND (z = 'B')), time_arr, event_arr, arrayPushBack(arrayPopFront(event_arr), cast('A', 'Enum8(\'A\' = 1, \'B\' = 2)'))) AS x
FROM
(
SELECT
userID,
eventType,
EventTime
FROM test.funnel
WHERE (Age > 30) AND (eventType IN ('A', 'B'))
ORDER BY
userID ASC,
EventTime ASC
)
GROUP BY userID
OG
R
SELECT
id,
sumIf(1, event_type="event_1") AS event_1,
sumIf(1, event_type="event_2") AS event_2,
sumIf(1, event_type="event_3") AS event_3,
и т.д.
DT
DT
OG
+------+----------+
|userID|x |
+------+----------+
|4 |1970-01-01|
|2 |1970-01-01|
|1 |2001-01-01|
+------+----------+
OG
OG
DT
OF
Syntax error: failed at position 6:
show users
Expected one of: TABLES, GRANTS, CREATE, QUOTA USAGE, POLICIES, ROW POLICIES, PROCESSLIST, CREATE, QUOTAS, DICTIONARIES
D
Syntax error: failed at position 6:
show users
Expected one of: TABLES, GRANTS, CREATE, QUOTA USAGE, POLICIES, ROW POLICIES, PROCESSLIST, CREATE, QUOTAS, DICTIONARIES
show users;
SHOW USERS
┌─name─────┐
│ default │
│ mtest │
│ ptest │
└──────────┘
3 rows in set. Elapsed: 0.002 sec.
D
VB
DC
EZ
