drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <abhishek.gir...@gmail.com>
Subject Re: WHERE clause causing a ClassCastException on HBase tables
Date Wed, 07 Sep 2016 19:13:31 GMT
Hello Ki,

You might not be receiving replies (attempting anyway). Your question did
get a response - pasting below for your reference.

---------- Forwarded message ----------
From: rahul challapalli <challapallirahul@gmail.com>
Date: Thu, Sep 1, 2016 at 11:09 AM
Subject: Re: WHERE clause causing a ClassCastException on HBase tables
To: dev <dev@drill.apache.org>


This is a bug. The query is failing at the planning state itself. Can you
raise a jira for the same with the details you posted here?

- Rahul

On Wed, Sep 7, 2016 at 11:01 AM, Ki Kang <Ki.Kang@ds-iq.com> wrote:

> I tried dev@drill.apache.org<mailto:dev@drill.apache.org>, but got no
> response, so I am hoping that user@drill.apache.org<mailto:u
> ser@drill.apache.org> will be able to help out.
> --------------------------------------------------------
> Can someone help or point me to where I can maybe get some help?
>
> I am trying to figure out why I am getting a ClassCastException when I do
> the following query.  If I change the "FROM" clause to just "FROM
> (VALUES(0))" it works just fine, but whenever I have "FROM" to an HBase
> table, I get the error.  I know that the HBase table is valid because if I
> remove the WHERE clause, the query does not throw an error.
>
> SELECT b.`date` FROM (
>   SELECT TO_DATE(CONCAT(a.`jArray`[0], '-', a.`jArray`[1], '-',
> a.`jArray`[2]), 'yyyy-MM-dd') `date` FROM (
>     SELECT CONVERT_FROM(REGEXP_REPLACE('["2016":"08":"03"]', ':', ','),
> 'JSON') `jArray`
>     --FROM (VALUES(0))
>     FROM `hbase`.`SomeValidTable`
>   ) a
> ) b
> WHERE b.`date` = '2016-08-03'
> LIMIT 1
>
> SYSTEM ERROR: ClassCastException: org.apache.drill.common.expression.FunctionCall
> cannot be cast to org.apache.drill.common.expression.SchemaPath
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message