We got into another issue. The below query is failing with “‘Cannot group by string columns which are not dictionary encoded.’”
“”“SELECT coalesce (sales1.m_unique_id , sales2.m_customer_name) as d, count(*) from #sales_orders as sales1 LEFT JOIN (select * from #sales_orders) as sales2 on sales1.m_unique_id = sales2.m_unique_id group by d”""
Can you please help to resolve this issue.
Please sign in to leave a comment.