我使用的是Hadoop的0.X版本。此版本中不允许使用子查询。有没有人可以帮我把下面的SQL转换成不使用子查询。
select 100 * stars / total from
(select count(rating) as stars
from ratingshive
where rating = 5) t1,
(select count(1) as total
from ratingshive) t2https://stackoverflow.com/questions/51345786
复制相似问题