hive问题，老师布置得题目，完全自己思路写的，帮忙看看，给点建议

老师布置的作业，完全按照自己思路想的，求大佬帮忙

hive> use test01;
OK
Time taken: 4.168 seconds
hive> select stu.*,a.s_score
    > from stu,
    > (select s1.s_score
    > from course,score s1,score s2
    > where course.c_id=score.c_id and (s1.c_id=01)>(s2.c_id=02)) a
    > where stu.s_id=a.s_id;
FAILED: SemanticException Cartesian products are disabled for safety reasons. If you know what you are doing, please sethive.strict.checks.cartesian.product to false and that hive.mapred.mode is not set to 'strict' to proceed. Note that if you may get errors or incorrect results if you make a mistake while using some of the unsafe features.

至少把表结构贴出来呀

//stu表
s_id,s_name,s_birth,s_sex
01,赵雷,1990-01-01,男
02,钱电,1990-12-21,男
03,孙风,1990-05-20,男
04,李云,1990-08-06,男
05,周梅,1991-12-01,女
06,吴兰,1992-03-01,女
07,郑竹,1989-07-01,女
08,王菊,1990-01-20,女


//score
s_id,c_id,s_score
01,01,80
01,02,90
01,03,99
02,01,70
02,02,60
02,03,80
03,01,80
03,02,80
03,03,80
04,01,50
04,02,30
04,03,20
05,01,76
05,02,87
06,01,31
06,03,34
07,02,89
07,03,98


//course
c_id,c_course,t_id
01,语文,02
02,数学,01
03,英语,03