PIVOT Table - Dynamic OutPut

Hello, I am trying to do some data pivoting in dremio as a part of requirements but struggling to achieve dynamic columns as an output. With SQL as backend it can be easily done in SQL but is a task in Dremio. Any pointers ? Is it even achievable with Dremio ?


Would you be able to provide an example SQL, when you say PIVOT, I assume you are referring to the PIVOT SQL function?

Yes, But Trying for Dynamic Columns but is a bug confirmed by Dremio and there is no workaround at the moment


Can you please provide the profile of the failed job so we can test it in house and verify?