Alicia Alvarez created DRILL-4607:
-------------------------------------
Summary: Add a split function that allows to separate string by a
delimiter
Key: DRILL-4607
URL: https://issues.apache.org/jira/browse/DRILL-4607
Project: Apache Drill
Issue Type: New Feature
Components: Functions - Drill
Affects Versions: 1.6.0
Reporter: Alicia Alvarez
Ex: Let's say I have records in a CSV file with the following schema
{noformat}
user_name, friend_list_separated_by_a_delimiter,other_fields
ali,sam;adi;tom,45,...
{noformat}
I want to run a query which returns the friend list files as a repeated value.
{noformat}
select user_name, split(friend_list, ';') friends from userdata;
{noformat}
This should return the records in the following format
{noformat}
---------------------------------
| user_name | friends |
---------------------------------
| ali | [sam, adi, tom] |
---------------------------------
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
