前些天发现了一个巨牛的人工智能学习网站,通俗易懂,风趣幽默,忍不住分享一下给大家。点击跳转到教程。

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. 解决:如下图,少一个逗号:


版权声明:本文为u011314442原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
原文链接:https://blog.csdn.net/u011314442/article/details/105971623