配置单元：无法执行带限制的联合查询

kuuvgm7e 于 2021-06-24 发布在 Hive

关注(0)|答案(1)|浏览(346)

我正在尝试在配置单元中运行union all查询

select * from tabName where col1='val1' and col2 = 'val2' limit 10 union all select * from tabName where col1='val1' and col2 = 'val3' limit 10;

但我明白了

FAILED: ParseException line 1:105 missing EOF at 'union' near '10'

我也试过了

( select * from tabName where col1='val1' and col2 = 'val2' limit 10 ) as a union all ( select * from tabName where col1='val1' and col2 = 'val3' limit 10 ) as b;

但我有

FAILED: ParseException line 1:109 missing EOF at 'as' near ')'

我做错什么了？

Hive union hiveql hive-query

来源：https://stackoverflow.com/questions/56777440/hive-cant-perform-union-query-with-limit

1条答案

按热度按时间

isr3a4wc1#

使用select from子查询：

select * from
( select * from tabName where col1='val1' and col2 = 'val2' limit 10 ) a 
union all 
select * from
( select * from tabName where col1='val1' and col2 = 'val3' limit 10 ) b;

赞(0）回复(0）举报 2021-06-24

我来回答

配置单元：无法执行带限制的联合查询

1条答案

相关问题

热门标签

最新问答