問(wèn)題描述：

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

SELECT?his.name, his.oid?FROM?his_data_zadd?AS?his?WHERE?his.value=(SELECT?MAX(temp_t.value)?FROMhis_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 found

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)

是spark sql的語(yǔ)法解析器不支持這種寫(xiě)法？還是sql語(yǔ)句原本就有問(wèn)題？

解決方法：

SELECT aa.user_id,
       aa.buyTimes,
       aa.sumOrderAmount
FROM  (SELECT user_id,
              Count(1)          AS buyTimes,
              Sum(a.real_price) AS sumOrderAmount,
              Max(real_price)   AS maxPrice
       FROM   global_temp.order a
       WHERE  1 = 1
          AND a.user_id = (SELECT Max(temp.user_id)
                           FROM   global_temp.order AS temp)
          AND a.status != 0
       GROUP  BY a.user_id)aa
WHERE  1 = 1
LIMIT  50;