I am using Dremio 3.3.2-201908142136370993-d60145d, community edition, I am trying to access postgres DB version 11. While giving this below query.
select country,date_part(‘year’,TO_DATE(orderdate,‘MM/DD/YYYY’)) as yearpart,sum(profit) as profit from “Dremio Fundamentals”.“sales postgres”
group by country, date_part(‘year’,TO_DATE(orderdate,‘MM/DD/YYYY’))
order by sum(profit) desc
@rajdct8q, Please send us the query profile