I am using presto for querying and joining results...
# troubleshooting
y
I am using presto for querying and joining results from Pinot, What is the recommended approach to do multiple aggregations like the following in single query ?
Copy code
select channel,
    sales_date,
    sum(sales) as sum_sales,
    sum(units) as sum_units
from pinot.default.sales
group by channel, sales_date
Currently presto is trying to fetch raw values for all the columns.
We found this
Copy code
pinot.allow-multiple-aggregations=true