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 <[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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
