DATA_READ ERROR: Error processing input: Cannot use newline character within quoted string

Hello Drill community, I'm seeing this error with Drill 1.5 when querying CSV or TSV data that contains quotes within some of the fields. I have a couple questions about this. 1. Does anyone know why Drill cares about quotes in the data? 2. Is there a workaround to this problem, besides

RE: Drill indexes

All, I didn't get any response on this question. Does anyone have a comment or advice for me? I didn't see anywhere in the Drill online docs that explain indexes or unique constraints. Did I miss something? Thanks, Scott Wilburn -Original Message- From: Wilburn, Scott

Drill indexes

Hello, Is there a way to index or create primary keys for fields in Drill? I'm interested in indexing for performance and also for creating unique constraints. If there is no way to create indexes, then is there another way to generate a unique constraint? Thanks, Scott Wilburn

RE: [E] Re: JDBC storage plugin fails

DRILL-4533 > > > > On Thursday, March 24, 2016, Wilburn, Scott > <scott.wilb...@verizonwireless.com.invalid> wrote: > >> Hello, >> I am trying to connect to a mysql database using the jdbc storage >> plugin using Drill 1.5 described here: >>

RE: [E] Re: dfs filename

not supported. You could track DRILL-3474 <https://issues.apache.org/jira/browse/DRILL-3474> / DRILL-3559 <https://issues.apache.org/jira/browse/DRILL-3559> for updates. On Mon, Mar 21, 2016 at 2:13 PM, Wilburn, Scott < scott.wilb...@verizonwireless.com.invalid> wrote: > He

dfs filename

Hello, Is there a way to query dfs csv files in multiple directories and include the filename as a field in the output? I created a view that is able to query over all of my directories, but I really need to know which file each record came from. For example, if my records have two columns,

RE: [E] Re: binary file searching

at 8:16 AM, Wilburn, Scott < scott.wilb...@verizonwireless.com.invalid> wrote: > Hello, > Is there a way to use Drill to search through binary files? I have > some binary files that require a special compiled tool to convert into > CSV format. Can Drill execute an external tool to con

binary file searching

Hello, Is there a way to use Drill to search through binary files? I have some binary files that require a special compiled tool to convert into CSV format. Can Drill execute an external tool to convert each file into ASCII before searching? Thanks, Scott Wilburn

RE: [E] Re: Date Format conversion

; > On Tue, Feb 23, 2016 at 10:41 AM, Wilburn, Scott < > scott.wilb...@verizonwireless.com.invalid> wrote: > > > Hello, > > Is there a way to convert other date formats into the DATE type? I > > would like to cast a field that contains a date in the forma

Date Format conversion

Hello, Is there a way to convert other date formats into the DATE type? I would like to cast a field that contains a date in the format mm/dd/, i.e "01/25/2016", into DATE type. Thanks, Scott Wilburn

RE: [E] Re: Multiple Delimiter Format

me now) I added very primitive XML support using the existing JSON classes and extending the reader as needed. Regards, Magnus > 19 feb 2016 kl. 04:18 skrev Jim Scott <jsc...@maprtech.com>: > > The delimited file reader does not support that. > > On Thu, Feb 18,

RE: [E] Re: Multiple Delimiter Format

. Jim On Thu, Feb 18, 2016 at 5:43 PM, Wilburn, Scott < scott.wilb...@verizonwireless.com.invalid> 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 com

Multiple Delimiter Format

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