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 <[email protected]> Date: Thu, Sep 1, 2016 at 11:09 AM Subject: Re: WHERE clause causing a ClassCastException on HBase tables To: dev <[email protected]> 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 <[email protected]> wrote: > I tried [email protected]<mailto:[email protected]>, but got no > response, so I am hoping that [email protected]<mailto:u > [email protected]> 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 > > >
