Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 141A4200B56 for ; Sat, 16 Jul 2016 04:06:27 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 129E3160A79; Sat, 16 Jul 2016 02:06:27 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 5AF59160A61 for ; Sat, 16 Jul 2016 04:06:26 +0200 (CEST) Received: (qmail 6086 invoked by uid 500); 16 Jul 2016 02:06:20 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 6070 invoked by uid 99); 16 Jul 2016 02:06:20 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 16 Jul 2016 02:06:20 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 6E94D2C0032 for ; Sat, 16 Jul 2016 02:06:20 +0000 (UTC) Date: Sat, 16 Jul 2016 02:06:20 +0000 (UTC) From: "Chunhui Shi (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Assigned] (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 X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Sat, 16 Jul 2016 02:06:27 -0000 [ https://issues.apache.org/jira/browse/DRILL-4783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunhui Shi reassigned DRILL-4783: ---------------------------------- Assignee: Chunhui Shi > 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)