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>