MAPREDUCE服务 MRS-WITH:多个子查询

时间:2024-09-19 09:08:44

多个子查询

with 
t1 as(select name,max(price) as maxprice from fruit group by name),
t2 as(select name,avg(price) as avgprice from fruit group by name)
select t1.*,t2.* from t1 join t2 on t1.name = t2.name;
support.huaweicloud.com/cmpntguide-lts-mrs/mrs_01_300178.html