I'm trying to SET hive.groupby.orderby.position.alias=true in py spark sql, but getting the error. AnalysisException: u"expression 'Dealer_D' is neither present in the group by, nor is it an aggregate function. Add to group by or wrap in first() (or first_value) if you don't care which value you get.;" Kindly help. ... View more