Status: Closed - Won't Fix
Affects Version/s: BIGDATA_RELEASE_1_2_3
Fix Version/s: None
Component/s: Bigdata SAIL
Normally aggregate functions are order independent, thus an order by on a select with an aggregate function can be ignored.
However, group_concat is order dependent.
With my test data the following query
returns "Female Male and Female N/A Both"
whereas the non-aggregate
The workaround is to push the ordering into a subselect.