Another question on the Trino Pinot connector. We ...
# troubleshootings
Stuart Millholland
03/16/2022, 5:03 PMAnother question on the Trino Pinot connector. We have a schema definition, and here are a couple sample fields:
Stuart Millholland
03/16/2022, 5:12 PMSo this query works fine (in both data grip and shelling into my trino coordinator pod)
Copy code
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'Stuart Millholland
03/16/2022, 5:12 PMNotice the account_type is commented out
Stuart Millholland
03/16/2022, 5:12 PMThis query returns nothing:
Copy code
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'Stuart Millholland
03/16/2022, 5:13 PMYet this query does:
Copy code
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'Stuart Millholland
03/16/2022, 5:13 PMIn my schema definition both tenant_name and account_type are defined exactly the same.