蜂巢查询数组总和

Question

我的查询如下。 Select split(Salary, '|') as salaryEmp from tableA，它可以正常工作，并给我一个数组字符串，为 ["1089","1078"]。

我想添加此数组字符串的值。我无法将其键入将其输入整数并总结。可以为此建议一种合适的方法。

Answer 1

select  sum(e.col) as sum_Salary
from    salaryEmp lateral view explode (split(Salary,'\|')) e

---

+------------+
| sum_salary |
+------------+
|       2167 |
+------------+

Answer 2

使用explode() lateral view：

select sum(cast(salary as int)) sum_salry from
 (
 select split('1089|1078', '\|') SalaryArray 
 ) s lateral view explode (SalaryArray) a as Salary;
OK
2167