[ https://issues.apache.org/jira/browse/DRILL-4607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15315178#comment-15315178 ]
ASF GitHub Bot commented on DRILL-4607: --------------------------------------- GitHub user parthchandra opened a pull request: https://github.com/apache/drill/pull/513 DRILL-4607: - Fix unittest failure. Janino cannot compile a function … …that uses generics; so replaced the implementation of StringFunctions.Split to not use any. You can merge this pull request into a Git repository by running: $ git pull https://github.com/parthchandra/drill DRILL-4607 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/drill/pull/513.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #513 ---- commit 130e565e00527c5632cd4b61cce19da734f70148 Author: Parth Chandra <par...@apache.org> Date: 2016-06-03T00:23:13Z DRILL-4607: - Fix unittest failure. Janino cannot compile a function that uses generics; so replaced the implementation of StringFunctions.Split to not use any. ---- > 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 > Assignee: Alicia Alvarez > Fix For: 1.7.0 > > > 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)