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, 2016 at 11:01 AM, Matt <bsg...@gmail.com> wrote: > Putting the "select * from > `/csv/customer/hourly/customer_201510170000.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)) > Aborting command > set because "force" is false and command failed: "select * from > `/csv/customer/hourly/customer_201510170000.csv`;" > Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl > ~~~ > > Is that index a byte or line offset? > > > On 26 Jan 2016, at 12:55, Abdel Hakim Deneche wrote: > > Does a select * on the same data also fail ? >> >> On Tue, Jan 26, 2016 at 9:44 AM, Matt <bsg...@gmail.com> wrote: >> >> 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 does contain a lot missing values for the numeric >>> columns, >>> and those are represented by as consecutive delimiters: >>> ""datetime,key,key,key,numeric,,,,,,..." >>> >>> Could this be causing the CTAS to fail with these types of errors? Or is >>> there another cause to look for? >>> >>> ~~~ >>> Error: SYSTEM ERROR: IllegalArgumentException: length: -260 (expected: >= >>> 0) >>> >>> │······························································· >>> >>> >>> >>> │······························································· >>> Fragment 1:2 >>> ~~~ >>> >>> >> >> >> -- >> >> Abdelhakim Deneche >> >> Software Engineer >> >> <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 >> > >> > -- Abdelhakim Deneche Software Engineer <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>
