t; +46 72 710 1935
> >> mpie...@maprtech.com | http://www.mapr.com
> >>
> >>
> >>
> >>> 19 feb 2016 kl. 16:29 skrev Wilburn, Scott
> >> <scott.wilb...@verizonwireless.com.INVALID>:
> >>>
> >>> Magnus,
> >>>
>>> Great suggestions. I would like to try to extend the functionality of
>> the "text" format type, used for csv files today. Do you know if there are
>> any published instructions for this process?
>>>
>>> Thanks,
>>> Scott Wilburn
>&
y, February 19, 2016 01:51 AM
> To: user@drill.apache.org
> Subject: Re: [E] Re: Multiple Delimiter Format
>
> Hello Scott,
>
> What you typically do is that you decide which separator will give you the
> most granular split (in your case comma) and then use SQL constructs to
ailto:mpie...@maprtech.com]
Sent: Friday, February 19, 2016 01:51 AM
To: user@drill.apache.org
Subject: Re: [E] Re: Multiple Delimiter Format
Hello Scott,
What you typically do is that you decide which separator will give you the most
granular split (in your case comma) and then use SQL constructs
Hello Scott,
What you typically do is that you decide which separator will give you the most
granular split (in your case comma) and then use SQL constructs to further
transform the returned columns of the set to the structure you would like to
have. In SQL you can always create additional
Jim,
Just to clarify, I'm trying to use Drill on files that contain records where
the fields are delimited by multiple different characters.
Example record: 10-20-16,4477,99;98,aab,99;66,aab
Desired result:
columns[0] = 10-20-16
columns[1] = 4477
columns[2] = 99
columns[3] = 98
columns[4] =