Channels
#troubleshooting
Title
# troubleshooting
s
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:
So 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'Notice the account_type is commented out
This 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'Yet 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'In my schema definition both tenant_name and account_type are defined exactly the same.