hive执行sql报错FAILED: ParseException line 1:50 character ' ' not supported here

最新推荐文章于 2024-07-02 14:52:41 发布

Hello stupid

最新推荐文章于 2024-07-02 14:52:41 发布

阅读量2k

点赞数

分类专栏：大数据bug 文章标签： hive

本文链接：https://blog.csdn.net/kinganne/article/details/101468435

版权

大数据bug 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

select user_id, (t1.s-t2.low_carbon)/t3.low_carbon from(
select user_id,sum(low_carbon)s
from atguigu.user_low_carbon where date_format(regexp_replace(data_dt,"/","-"),"yyyy-MM") < "2017-10"
group by user_id order by s desc limit 10)t1,
(select low_carbon from plant_carbon where plant_id="p004")t2,
(select low_carbon from plant_carbon where plant_id ="p002")t3;

报错：FAILED: ParseException line 1:50 character ’ ’ not supported here

原因：sql 语句等号左边有空格！！！真的恶心