How to split a column?

Question

I would like to see if I can split a column in spark data. Like this,

Select employee, split(department,"_") from Employee

+6

ashK Mar 24 '16 at 12:20

1 answer

David Griffin · Accepted Answer · 2016-03-24T14:21:02+0000

Try the following:

 SELECT explode(split(str, '_'))

Or that:

 SELECT split(str, ' ')[0] as part1, split(str, ' ')[1] as part2