解決： Error while compiling statement: FAILED: ParseException line 23:13 extraneous input ‘(‘ expectin

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

1. hive 執行sql，報錯：

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

2. sql 如下 ：

SELECT
	pxx_id,
	pxxx_name,
	xxx,
	creationtime,
	creatorid,
	lastxxxxntime,
	lxxxierid,
	NULL,
	NULL,
    NULL 
FROM
	(
SELECT
	pxx_id,
	pxxx_name,
	xxx,
	creationtime,
	creatorid,
	lastxxxxntime,
	lxxxierid,
	NULL,
	NULL
	NULL Row_number ( ) OVER ( PARTITION BY xxx ORDER BY xxx DESC ) AS num 
FROM
	xxx.bxxxi_xxxts_xxxce 
	) bcp 
WHERE
	bcp.num = 1;
           

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