在Hive中选择方括号和引号之间的值

作者: v-star*위위
发布时间: 2024-03-17 08:46:38 (1月前)
转自：

3 条回复

0#
回复此人
哈哈哈哈 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <pre> <code> hive> with t1 as (select cast(1 as string) as col1 union select cast(2 as string) as col1 union select cast(3 as string) as col1) select collect_set(col1), concat_ws(',', collect_set(col1)) from t1; OK ["1","2","3"] 1,2,3 Time taken: 95.27 seconds, Fetched: 1 row(s) </code> </pre> <BLOCKQUOTE> <BLOCKQUOTE> <P> concat_ws只接受字符串值数组 </p> </BLOCKQUOTE> </BLOCKQUOTE> <P> 如果项目数量是固定的，那么您也可以使用 </p> <pre> <code> hive> with t1 as (select cast(1 as string) as col1 union select cast(2 as string) as col1 union select cast(3 as string) as col1) select concat(collect_set(col1)[0], ',' ,collect_set(col1)[1], ',', collect_set(col1)[2]) from t1; </code> </pre> </DIV>

编辑
1#
回复此人
Moso31 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 使用 <code> concat_ws </code> 从一开始就加入字符串数组： </p> <pre> <code> SELECT concat_ws(', ', collect_set(col_name)) AS my_col FROM my_table ^ ---------------------------------- ^ </code> </pre> <P> 该 <a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringFunctions" rel="nofollow noreferrer"> <code> concat_ws </code> </A> 因为你有一个字符串数组，而不是一个字符串，所以更合适。 </p> </DIV>

编辑

登录后才能参与评论