I am currently working on implementing a group-wise z-standardization for a numeric variable.
For this, I create a subquery to calculate the mean and std. deviation for each group and plan to use this inside of a larger query with the actual values to then calculate the z-standardization.
When I run the subquery by itself it works fine but when I include it inside the larger query it gives me back the “Exception: Aggregate function STDDEV not supported”. However, the other aggregate function AVG seems to work just fine.
Could you advise on whether this is a limitation of OmniSciDB or whether this is a problem in my approach.
Thank you so much in advance!