drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aman Sinha <amansi...@apache.org>
Subject Re: select count(1) : Cannot convert Indexed schema to NamePart
Date Wed, 28 Sep 2016 16:33:13 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message