Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
MIME-Version: 1.0
In-Reply-To: <CAFyDVv+joBa1AjqupD7y-EdEMhHFhanYfX794PXFK-A0=+ziyw@mail.gmail.com>
References: <CAB=0=1-d6eYrLZsQ+MJfZpiBQrvMPdJ0XR7T9p5P_aT_jHcN0g@mail.gmail.com>
 <CAFyDVv+joBa1AjqupD7y-EdEMhHFhanYfX794PXFK-A0=+ziyw@mail.gmail.com>
From: Jinfeng Ni <jni@apache.org>
Date: Wed, 28 Sep 2016 10:01:54 -0700
Message-ID: <CAK55V=LaBoJy9yaktFpBwG6K-m=1swEOcNeuTgeLajU-naxrLw@mail.gmail.com>
Subject: Re: select count(1) : Cannot convert Indexed schema to NamePart
To: dev <dev@drill.apache.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
archived-at: Wed, 28 Sep 2016 17:01:57 -0000

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 <amansinha@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=C3=A7ois M=C3=A9thot <fmethot78@gma=
il.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 Vector=
s,
>> not individual records or values.
>>
>> same error with
>>    select count(1) from hdfs.datarepo1.`/` where dir0=3D2016 and dir1=3D=
08;
>>
>>
>> While this query works (or any select column)
>>    select count(column1) from hdfs.datarepo1.`/2016/08`;
>>
>>
>> Should I create a ticket?
>>
>>
>> Francois
>>