Hive SQL语句的正确执行顺序
复制select
sum(b.order_amount) sum_amount,
count(a.userkey) count_user
from user_info a
leftjoin user_order b
on a.idno=b.idno
where a.idno > 112233
groupby a.idno
having count_user>1
limit 10;
1.2.3.4.5.6.7.8.9.10.
THE END
