drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alicia Alvarez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4607) Add a split function that allows to separate string by a delimiter
Date Thu, 14 Apr 2016 22:24:25 GMT
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)

Mime
View raw message