Thanks Abdel, Just went and checked the data file I had downloaded and that is the issue, thanks!
On Tue, Dec 29, 2015 at 9:49 AM, Abdel Hakim Deneche <[email protected]> wrote: > Hello Stefan, > > Did you create the .csvh file on a Windows machine ? > We have a known issue DRILL-3726 > <https://issues.apache.org/jira/browse/DRILL-3726> where Drill doesn't > interpret CRLF properly. > > On Tue, Dec 29, 2015 at 9:44 AM, Stefan Sedich <[email protected]> > wrote: > > > Hi, > > > > I have the following csv file and I am using the .csvh extension so that > > Drill parses headers for me: > > > > a,b,c,d > > 1,2,3,4 > > > > If I were to execute a SELECT * FROM sample.csvh, the results are correct > > and I can see the data. > > > > Now If I try to execute SELECT d FROM sample.csvh I get nothing back, I > can > > select a,b or c perfectly fine but not the last column which is > > demonstrated by adding another column onto the end and selecting d again > > which works perfectly fine. > > > > I went back to Drill 1.3 and I get an exception when attempting to select > > the last column, is anyone else seeing this? > > > > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > > ArrayIndexOutOfBoundsException: -1 Fragment 0:0 [Error Id: > > 0320cda6-c6cb-4892-86ec-0c168849767f on 0462-SSED-T430S:31010] > > > > -- > > Cheers > > Stefan > > > > > > -- > > 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 > > > -- Cheers Stefan
