Re: CTAS error with CSV data

https://issues.apache.org/jira/browse/DRILL-4317 On 26 Jan 2016, at 23:50, Abdel Hakim Deneche wrote: This definitely looks like a bug, could you open a JIRA and share as much information as possible about the structure of the CSV file and the number of records. On Tue, Jan 26, 2016 at 7:38

Re: CTAS error with CSV data

This definitely looks like a bug, could you open a JIRA and share as much information as possible about the structure of the CSV file and the number of records. On Tue, Jan 26, 2016 at 7:38 PM, Matt wrote: > The CTAS with fails with: > > ~~~ > Error: SYSTEM ERROR:

CTAS error with CSV data

Getting some errors when attempting to create Parquet files from CSV data, and trying to determine if it is due to the format of the source data. Its a fairly simple format of "datetime,key,key,key,numeric,numeric,numeric, ..." with 32 of those numeric columns in total. The source data

Re: CTAS error with CSV data

Putting the "select * from `/csv/customer/hourly/customer_20151017.csv`;" in a local .sql file, and executing it with sqlline > /dev/null (to avoid a ton of scrolling) results in: ~~~ index: 418719, length: 2 (expected: range(0, 418719))

Re: CTAS error with CSV data

It's an internal buffer index. Can you try enabling verbose errors and run the query again, this should provide us with more details about the error. You can enable verbose error by running the following before the select *: alter session set `exec.errors.verbose`=true; thanks On Tue, Jan 26,

Re: CTAS error with CSV data

The CTAS with fails with: ~~~ Error: SYSTEM ERROR: IllegalArgumentException: length: -260 (expected: >= 0) Fragment 1:2 [Error Id: 1807615e-4385-4f85-8402-5900aaa568e9 on es07:31010] (java.lang.IllegalArgumentException) length: -260 (expected: >= 0)