表达式规范中“order”附近的“(”处缺少

yzxexxkh  于 2021-06-26  发布在  Hive
关注(0)|答案(0)|浏览(362)

我得到这个错误:
u“第2:34行在表达式规范的'order'附近缺少('near'order'\n第2:41行输入不匹配'by'应为)在表达式规范的'order'附近
当我跑步时:

customer_cutoff3=sqlContext.sql("""
select category,
PERCENTILE_DISC(0.4) WITHIN GROUP (ORDER BY ty_spend) OVER (PARTITION BY category ) as low_spend_cutoff
from customer_cutoff2
where ty_visits>0
group by category
""").toPandas()

有人能帮我吗?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题