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>
