drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ki Kang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4885) WHERE clause causing a ClassCastException on HBase tables
Date Fri, 09 Sep 2016 22:26:20 GMT
Ki Kang created DRILL-4885:
------------------------------

             Summary: WHERE clause causing a ClassCastException on HBase tables
                 Key: DRILL-4885
                 URL: https://issues.apache.org/jira/browse/DRILL-4885
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.5.0
            Reporter: Ki Kang


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

<<copy/paste from a email response from Rahul>>
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




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message