PIVOT Table - Dynamic OutPut

Dremio Cloud
1

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 ?

2

@Jinesh

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

3

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

4

@Jinesh

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

Thanks