drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chunhui Shi (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4783) Flatten on CONVERT_FROM fails with ClassCastException if resultset is empty
Date Sat, 16 Jul 2016 01:42:20 GMT
Chunhui Shi created DRILL-4783:
----------------------------------

             Summary: Flatten on CONVERT_FROM fails with ClassCastException if resultset is
empty
                 Key: DRILL-4783
                 URL: https://issues.apache.org/jira/browse/DRILL-4783
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Chunhui Shi
            Priority: Critical


Flatten failed to work on top of convert_from when the resultset is empty. 

For a HBase table like this:

0: jdbc:drill:zk=localhost:5181> select convert_from(t.address.cities,'json') from hbase.`/tmp/flattentest`
t;
+----------------------------------------------------------------------------------+
|                                      EXPR$0                                      |
+----------------------------------------------------------------------------------+
| {"list":[{"city":"SunnyVale"},{"city":"Palo Alto"},{"city":"Mountain View"}]}    |
| {"list":[{"city":"Seattle"},{"city":"Bellevue"},{"city":"Renton"}]}              |
| {"list":[{"city":"Minneapolis"},{"city":"Falcon Heights"},{"city":"San Paul"}]}  |
+----------------------------------------------------------------------------------+

Flatten works when row_key is in (1,2,3)
0: jdbc:drill:zk=localhost:5181> select flatten(t1.json.list) from (select convert_from(t.address.cities,'json')
json from hbase.`/tmp/flattentest` t where row_key=1) t1;
+---------------------------+
|          EXPR$0           |
+---------------------------+
| {"city":"SunnyVale"}      |
| {"city":"Palo Alto"}      |
| {"city":"Mountain View"}  |
+---------------------------+

But Flatten throws exception if the resultset is empty

0: jdbc:drill:zk=localhost:5181> select flatten(t1.json.list) from (select convert_from(t.address.cities,'json')
json from hbase.`/tmp/flattentest` t where row_key=4) t1;
Error: SYSTEM ERROR: ClassCastException: Cannot cast org.apache.drill.exec.vector.NullableIntVector
to org.apache.drill.exec.vector.complex.RepeatedValueVector

Fragment 0:0

[Error Id: 07fd0cab-d1e6-4259-bfec-ad80f02d93a2 on atsqa4-127.qa.lab:31010] (state=,code=0)






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

Mime
View raw message