前些天發現了一個巨牛的人工智能學習網站，通俗易懂，風趣幽默，忍不住分享一下給大家。點擊跳轉到教程。

1. hive 執行sql，報錯：

 Error while compiling statement: FAILED: 
ParseException line 23:13 extraneous input '(' expecting ) near ')' in subquery source

2. sql 如下 ：

SELECTpxx_id,pxxx_name,xxx,creationtime,creatorid,lastxxxxntime,lxxxierid,NULL,NULL,NULL 
FROM(
SELECTpxx_id,pxxx_name,xxx,creationtime,creatorid,lastxxxxntime,lxxxierid,NULL,NULLNULL Row_number ( ) OVER ( PARTITION BY xxx ORDER BY xxx DESC ) AS num 
FROMxxx.bxxxi_xxxts_xxxce ) bcp 
WHEREbcp.num = 1;

3. 解決：如下圖，少一個逗號：