[DRILL-4607] Add a split function that allows to separate string by a delimiter

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.6.0
• Fix Version/s: 1.7.0
• Component/s: Functions - Drill
• Labels: doc-impacting
• Assignee: Alicia Alvarez
• Reporter: Alicia Alvarez
• Reviewer: Sudheesh Katkam
• Created: 14/Apr/16 22:24
• Updated: 13/Jun/16 20:24
• Resolved: 02/Jun/16 18:08

Description

Ex: Let's say I have records in a CSV file with the following schema

user_name, friend_list_separated_by_a_delimiter,other_fields
ali,sam;adi;tom,45,...

I want to run a query which returns the friend list files as a repeated value.

select user_name, split(friend_list, ';') friends from userdata;

This should return the records in the following format

---------------------------------
| user_name |       friends     |
---------------------------------
|   ali     |  [sam, adi, tom]  |
---------------------------------

Issue Links

• links to: GitHub Pull Request #481
• links to: GitHub Pull Request #506
• links to: GitHub Pull Request #513