I have created a ticket: https://issues.apache.org/jira/browse/DRILL-4919
The error happen on csv with header. The actual error from the Drill's original TextFormatPlugin is Error: UNSUPPORTED_OPERATION ERROR: With extractHeader enabled, only header names are supported Forget about the originally reported error, it happens on a modified version of the TextFormatPlugin we are using. On Wed, Sep 28, 2016 at 1:01 PM, Jinfeng Ni <j...@apache.org> wrote: > I tried to query a regular csv file and a csv.gz file, and did not run > into the problem you saw. When you create a JIRA, it would be helpful > if you can share a sample file for re-produce purpose. > > > > On Wed, Sep 28, 2016 at 9:33 AM, Aman Sinha <amansi...@apache.org> wrote: > > Is this specific to CSV format files ? Yes, you should create a JIRA for > > this. Thanks for reporting. > > > > On Wed, Sep 28, 2016 at 8:55 AM, François Méthot <fmetho...@gmail.com> > > wrote: > > > >> Hi, > >> > >> Since release 1.8, > >> > >> we have a workspace hdfs.datarepo1 mapped to > >> /year/month/day/ > >> containging csv.gz > >> > >> if we do select count(1) on any level of the dir structure like > >> select count(1) from hdfs.datarepo1.`/2016/08`; > >> We get > >> Error: SYSTEM ERROR: IllegalStateException: You cannot convert a > >> indexed schema path to a NamePart. NameParts can only reference > Vectors, > >> not individual records or values. > >> > >> same error with > >> select count(1) from hdfs.datarepo1.`/` where dir0=2016 and dir1=08; > >> > >> > >> While this query works (or any select column) > >> select count(column1) from hdfs.datarepo1.`/2016/08`; > >> > >> > >> Should I create a ticket? > >> > >> > >> Francois > >> >
