34 lines
No EOL
1.1 KiB
Text
Executable file
34 lines
No EOL
1.1 KiB
Text
Executable file
SELECT string_arr.1 AS StringKey,
|
|
string_arr.2 AS StringValue,
|
|
numeric_arr.1 AS NumericKey,
|
|
count() AS Events,
|
|
median(numeric_arr.2) AS Median,
|
|
min(numeric_arr.2) AS Min,
|
|
max(numeric_arr.2) AS Max,
|
|
sum(numeric_arr.2) AS Sum
|
|
FROM (
|
|
SELECT * FROM (
|
|
SELECT JSONExtractKeysAndValues(string_props, 'String') AS string_arr,
|
|
JSONExtractKeysAndValues(numeric_props, 'Float') AS numeric_arr
|
|
FROM events
|
|
PREWHERE app_id = '{{app_id}}'
|
|
WHERE 1 = 1
|
|
{% if date_from and date_to %}
|
|
AND timestamp BETWEEN '{{date_from}}' AND '{{date_to}}'
|
|
{% endif %}
|
|
{% if country_code %}
|
|
AND country_code = '{{country_code}}'
|
|
{% endif %}
|
|
{% if event_name %}
|
|
AND event_name = '{{event_name}}'
|
|
{% endif %}
|
|
{% if os_name %}
|
|
AND os_name = '{{os_name}}'
|
|
{% endif %}
|
|
{% if app_version %}
|
|
AND app_version = '{{app_version}}'
|
|
{% endif %}
|
|
) LEFT ARRAY JOIN string_arr
|
|
) LEFT ARRAY JOIN numeric_arr
|
|
GROUP BY StringKey, StringValue, NumericKey
|
|
ORDER BY StringKey, Events DESC |