問(wèn)題描述

spark sql中運(yùn)行報(bào)錯(cuò)

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)

報(bào)錯(cuò)信息：

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的語(yǔ)法解析器不支持這種寫(xiě)法？還是我的sql語(yǔ)句原本就有問(wèn)題？

問(wèn)題解答

試下把SQLContext換成HiveContext