本文主要是介绍解决: 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 如下 :
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. 解决:如下图,少一个逗号:
这篇关于解决: Error while compiling statement: FAILED: ParseException line 23:13 extraneous input ‘(‘ expectin的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!