Stuart Millholland
03/16/2022, 5:03 PMSELECT *
FROM pinot.default."
SELECT country,
account_type,
COUNT(1) row_count
FROM immutable_unified_events
WHERE tenant_name = 'tenant1'
AND user_is_admin = true
--AND account_type = 'Internal'
GROUP BY country,
account_type
LIMIT 50000"
WHERE country = 'Congo'
SELECT *
FROM pinot.default."
SELECT country,
account_type,
COUNT(1) row_count
FROM immutable_unified_events
WHERE tenant_name = 'tenant1'
AND user_is_admin = true
AND account_type = 'Internal'
GROUP BY country,
account_type
LIMIT 50000"
WHERE country = 'Congo'
SELECT *
FROM pinot.default."
SELECT country,
account_type,
COUNT(1) row_count
FROM immutable_unified_events
WHERE tenant_name = 'tenant1'
AND user_is_admin = true
GROUP BY country,
account_type
LIMIT 50000"
WHERE country = 'Congo'
AND account_type = 'Internal'