filter pushdown and looker empty points

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 syntax
from_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

0 replies

Be the first to reply!