drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jinfeng Ni <...@apache.org>
Subject Re: select count(1) : Cannot convert Indexed schema to NamePart
Date Wed, 28 Sep 2016 17:01:54 GMT
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çois Méthot <fmethot78@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
>>

Mime
View raw message