Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Thu, 21 Jul 2016 18:25:20 +0000 (UTC)
From: "ASF GitHub Bot (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12989998.1468633336000.98381.1469125520805@Atlassian.JIRA>
In-Reply-To: <JIRA.12989998.1468633336000@Atlassian.JIRA>
References: <JIRA.12989998.1468633336000@Atlassian.JIRA> <JIRA.12989998.1468633336963@arcas>
Subject: [jira] [Commented] (DRILL-4783) Flatten on CONVERT_FROM fails with
 ClassCastException if resultset is empty
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 21 Jul 2016 18:25:22 -0000


    [ https://issues.apache.org/jira/browse/DRILL-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15388161#comment-15388161 ] 

ASF GitHub Bot commented on DRILL-4783:
---------------------------------------

Github user jinfengni commented on a diff in the pull request:

    https://github.com/apache/drill/pull/546#discussion_r71760001
  
    --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/flatten/FlattenRecordBatch.java ---
    @@ -267,10 +276,21 @@ private TransferPair getFlattenFieldTransferPair(FieldReference reference) {
         if (flattenField instanceof RepeatedMapVector) {
           tp = ((RepeatedMapVector)flattenField).getTransferPairToSingleMap(reference.getAsNamePart().getName(), oContext.getAllocator());
         } else {
    -      final ValueVector vvIn = RepeatedValueVector.class.cast(flattenField).getDataVector();
    -      // vvIn may be null because of fast schema return for repeated list vectors
    -      if (vvIn != null) {
    -        tp = vvIn.getTransferPair(reference.getAsNamePart().getName(), oContext.getAllocator());
    +      try {
    +        final ValueVector vvIn = RepeatedValueVector.class.cast(flattenField).getDataVector();
    +        // vvIn may be null because of fast schema return for repeated list vectors
    +        if (vvIn != null) {
    +          tp = vvIn.getTransferPair(reference.getAsNamePart().getName(), oContext.getAllocator());
    +        }
    +      } catch(ClassCastException ex) {
    --- End diff --
    
    We can apply similar changes above here ( catch ClassCastException -> instancOf check), also, logger same message. 


> 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
>            Assignee: 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)