I have posted this in plyql user group too. I am posting here in case others have implemented anything similar in their druid implementation.
Do we have support for CASE statement in plyql? I am trying to group couple of dimensional values into one bucket. Below is the Druid Data Store structure in plyql. I want to combine couple of dimension elements into one bucket as in the below case statement.
case when cust_type = ‘active_shopper’ or cust_type = ‘inactive_shopper’ then ‘shopper’ else ‘non-shopper’ end as type
Also we are using Tableau as our front end and we prefer the queries generated by Tableau for plyql interaction instead of custom written queries. Any help will be much appreciated.