Hive table’s column, PEOPLE has a value “jihee,jong,hemo”. What
string
function I have to use to separate the string by comma ‘,’ to
generate an
array value, [“jihee”, “jong”, “hemo”]?
a. SEPERATE(PEOPLE, ‘,’)
b. SPLIT(PEOPLE, ‘,’)
c. SEPARATE_BY_COMMA(PEOPLE)
d. SPLIT_BY_COMMA(PEOPLE)
Hive table’s column, PEOPLE has a value “jihee,jong,hemo”. What string function I have to use to separate the string by
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Hive table’s column, PEOPLE has a value “jihee,jong,hemo”. What string function I have to use to separate the string by
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!