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] = aab columns[5] = 99 columns[6] = 66 columns[7] = aab In this example, the record contains 8 fields when split by comma and by semicolon. Is something like this possible? Thanks, Scott Wilburn -----Original Message----- From: Jim Scott [mailto:[email protected]] Sent: Thursday, February 18, 2016 03:46 PM To: user Subject: [E] Re: Multiple Delimiter Format Scott, You would need a format defined for each file type. e.g. csv has commas, tsv has tabs, so on If you are looking for multiple delimiters within the same file or potentially with a single file extension that isn't supported. Jim On Thu, Feb 18, 2016 at 5:43 PM, Wilburn, Scott < [email protected]> wrote: > Hello, > Is there a way to specify multiple delimiters when configuring a > storage plugin record format? For example, could I split records into > fields by comma or by semicolon characters. > > Thanks, > Scott Wilburn > > -- *Jim Scott* Director, Enterprise Strategy & Architecture +1 (347) 746-9281 @kingmesal <https://twitter.com/kingmesal> <http://www.mapr.com/> [image: MapR Technologies] <http://www.mapr.com> Now Available - Free Hadoop On-Demand Training <http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
