IS there a looker-pinot connector ?
We are using Trino to fetch data stored in Pinot , via Looker
In table the field created_at
stores the epoch_timestamp in integer datatype.
While querying, looker generates filter on the above field, with the syntaxfrom_unixtime(table1.created_at) AT TIMEZONE 'Asia/Kolkata'
this doesnt get pushdown, and Trino tries to load entire table any workaround for this?
If we add some more filters what looker does is when pivoting the data it adds those empty data point sto visualization even thought the trinio query returns filtered data points
filter pushdown and looker empty points
Be the first to reply!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.