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;

這個(gè)會報(bào)錯(cuò)FAILED: SemanticException [Error 10001]: Line 13:6 Table not found 'tb2'

答：hive的用法基本和標(biāo)準(zhǔn)SQL相同差異并不大。錯(cuò)誤點(diǎn)在別名與括號之間需要有空格