hive sql报错ParseException in subquery source

最新推荐文章于 2023-10-13 14:32:56 发布

dair6

最新推荐文章于 2023-10-13 14:32:56 发布

阅读量4.8k

点赞数 1

分类专栏： sql相关问题文章标签： hive sql hadoop

本文链接：https://blog.csdn.net/dair6/article/details/122061595

版权

sql相关问题专栏收录该内容

14 篇文章 3 订阅

订阅专栏

hive sql报错ParseException in subquery source

org.apache.hadoop.hive.ql.parse.ParseException:line 368:18 cannot recognize input near ‘group’ ‘by’ ‘order_phone_num’ in subquery source

sql：

     customer_Flag as (

                  select order_phone_num,
                         concat_ws(';', collect_list(c)) as a,
                         sum(customer_flag)              as b
                  from (
                           select order_phone_num,
                                  customer_flag,
                                  concat_ws(',', collect_list(cast(r_diff as string))) as c
                            from add_payment_period
                           group by order_phone_num,
                                    customer_flag
                       )
                  group by order_phone_num

     ),

解决办法：给最外层的group by order_phone_num加上一个别名c1

     customer_Flag as (

                  select order_phone_num,
                         concat_ws(';', collect_list(c)) as a,
                         sum(customer_flag)              as b
                  from (
                           select order_phone_num,
                                  customer_flag,
                                  concat_ws(',', collect_list(cast(r_diff as string))) as c
                            from add_payment_period
                           group by order_phone_num,
                                    customer_flag
                       ) c1
                  group by order_phone_num

     ),