Error while compiling statement: FAILED: SemanticException [Error 10025]: line 1:7 Expression not in GROUP BY key 'sex'

SELECT collect_set(t_user.sex)[0] AS sex, t_movie.moviename,        AVG(t_rating.rate) AS avgrate, COUNT(*) AS total    FROM hive_sql_test1.t_user AS t_user    INNER JOIN hive_sql_test1.t_rating AS t_rating        ON t_user.userid=t_rating.userid    INNER JOIN hive_sql_test1.t_movie AS t_movie        ON t_movie.movieid=t_rating.movieid    WHERE t_user.sex='M'    GROUP BY t_movie.moviename    HAVING total>50    ORDER BY avgrate DESC    LIMIT 10;

CREATE TABLE A (    X varchar(255));
CREATE TABLE B (    Y varchar(255));
INSERT INTO A VALUES ('Amy'), ('John'), ('Lisa'), ('Marco'), ('Phil');INSERT INTO B VALUES ('Lisa'), ('Marco'), ('Phil'), ('Tim'),('Vincent');
SELECT B.Y FROM A    LEFT SEMI JOIN B    ON A.X = B.Y

SELECT B.Y FROM A	WHERE A.X  IN (SELECT B.Y FROM B);