Hive table’s column, PEOPLE has a value “jihee,jong,hemo”. What string function I have to use to separate the string by
Posted: Thu May 05, 2022 12:50 pm
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)
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)