HQL Failed rule: 'regularBody' in statement

Error: Error while compiling statement: FAILED: ParseException line 3:0 Failed to recognize predicate 'a'. Failed rule: 'regularBody' in statement (state=42000,code=40000)

查看创建和插入语句的语法是否有错误，在创建表并插入中要加上 as。

create table dw_comment_gender as 
select tmp_mv_male.malecnt as male_cnt ,
tmp_mv_female.femalecnt as female_cnt,
tmp_mv_male.mvid as mvid
from tmp_mv_male ,tmp_mv_female
where tmp_mv_male .mvid = tmp_mv_female.mvid;