https://pinot.apache.org/ logo
#troubleshooting
Title
# troubleshooting
s

Stuart Millholland

03/16/2022, 5:03 PM
Another 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.