成人在线亚洲_国产日韩视频一区二区三区_久久久国产精品_99国内精品久久久久久久

您的位置:首頁技術(shù)文章
文章詳情頁

mysql - spark sql嵌套查詢語法問題

瀏覽:102日期:2022-06-22 08:18:31

問題描述

spark sql中運行報錯

SQL:

SELECT his.name, his.oid FROM his_data_zadd AS his WHERE his.value=(SELECT MAX(temp_t.value) FROM his_data_zadd AS temp_t)

報錯信息:

py4j.protocol.Py4JJavaError: An error occurred while calling o32.sql.: java.lang.RuntimeException: [1.76] failure: ``)’’ expected but identifier MAX foundSELECT his.name, his.oid FROM his_data_zadd AS his WHERE his.value=(SELECT MAX(temp_t.value) FROM his_data_zadd AS temp_t)

是spark sql的語法解析器不支持這種寫法?還是我的sql語句原本就有問題?

問題解答

回答1:

試下把SQLContext換成HiveContext

相關(guān)文章: