扫码加入数据分析学习群

SELECT tb2.name   
FROM(
      SELECT tb1.season, tb1.name, ROW_NUMBER() OVER(
                                                     ORDER BY SUBSTR(tb1.season, 2, 4)                                                     ) AS number  --增加序号
      FROM(
           SELECT a.season, a.name, a.scores  --赛季，得分王，得分
           FROM (
                 SELECT season, max(scores) scores
                 FROM player
                 GROUP BY season
                )
           b JOIN player a ON a.season = b.season AND a.scores = b.scores
    )tb1 
)tb2,tb3
WHERE tb2.season=tb3.season AND tb2.name=tb3.name AND tb2.number=tb3.number-1;

这个会报错FAILED: SemanticException [Error 10001]: Line 13:6 Table not found 'tb2'

答：hive的用法基本和标准SQL相同差异并不大。错误点在别名与括号之间需要有空格