From user-return-6810-apmail-drill-user-archive=drill.apache.org@drill.apache.org Wed Sep 7 19:14:24 2016 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 80E6419AAD for ; Wed, 7 Sep 2016 19:14:24 +0000 (UTC) Received: (qmail 34010 invoked by uid 500); 7 Sep 2016 19:14:24 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 33948 invoked by uid 500); 7 Sep 2016 19:14:24 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 33933 invoked by uid 99); 7 Sep 2016 19:14:23 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Sep 2016 19:14:23 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 683A7181061 for ; Wed, 7 Sep 2016 19:14:23 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id AfAoHftrKaaC for ; Wed, 7 Sep 2016 19:14:20 +0000 (UTC) Received: from mail-lf0-f47.google.com (mail-lf0-f47.google.com [209.85.215.47]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 679655FC21 for ; Wed, 7 Sep 2016 19:14:20 +0000 (UTC) Received: by mail-lf0-f47.google.com with SMTP id l131so5505238lfl.2 for ; Wed, 07 Sep 2016 12:14:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=xIL7vZ2FKL6MHGBoXGXaBDsHkqJQQ9jwnb2VFrpIR20=; b=lQ5ObHQowMNd2CxPDifBi8YYCPOV9uDDY0xe4dOs9/h161vpnFKOy/ft80k0tZaF6v 1ahC6M5R9VL/k3YBx23gfcT5t9xs6h8AGFavzoVDIme7l2j05ajJhbL/cwq20uH2ILQQ Td9ipmMyv8dstG6TtKcwHk+2mHhYlPnOnD4kzZzjGVKlL5Hm9vV01+w6qMFIf2ur8Wkq ycoSgacYWcScLqffRdkyJTY+DllDI5lFp8U9ym4HWrxAAj+Xi/Neid0RVemWdq+yEwuy SiaDoO+fCf/A02n3wCQH9FjSnid6Lz4evwdd5EERzKBXWhCxvpv83I19lnZ17fAkQlSx MjxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=xIL7vZ2FKL6MHGBoXGXaBDsHkqJQQ9jwnb2VFrpIR20=; b=C8sxYyMk6ZCeQXluqbo9Ue8BEXAI78soQ5TLtXOQatp+rs+hxYau0U2sBdIvB8UEkS 6nCiQFKXZkZ1kk1LM90aGHRDpXMurMcR4vNuE4qYy+wz7qRC/hisaY4SuUjc88sByBlj B305aRFmHSEUM3+9Cit49X5fol4R5fcK2c9ZZ4uQ5oiSM7OP2OJZ45Mg9PsNv3gfTlN1 HFx/mXKysNHf/vmxpfNLYekVx3FRfqZGxWrZE8jnMjpvI1yROReDQmpUJjFvvCmvRF5e 10zB8ZkeZY4A7LtztBAWk+DSICvx99juplnRbDhivdVS1NX6YhVIFObyExyXwPcqmSVd C1OQ== X-Gm-Message-State: AE9vXwP4MKaHmiCtbXVkqkVczyLl/393a/pltMud9csGva4x4YJ0EH2LxZshpNN8gO4dHA== X-Received: by 10.25.80.208 with SMTP id e199mr366949lfb.115.1473275653100; Wed, 07 Sep 2016 12:14:13 -0700 (PDT) Received: from mail-lf0-f45.google.com (mail-lf0-f45.google.com. [209.85.215.45]) by smtp.gmail.com with ESMTPSA id o10sm221666lfo.47.2016.09.07.12.14.11 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 07 Sep 2016 12:14:11 -0700 (PDT) Received: by mail-lf0-f45.google.com with SMTP id g62so5461919lfe.3 for ; Wed, 07 Sep 2016 12:14:11 -0700 (PDT) X-Received: by 10.25.5.9 with SMTP id 9mr480643lff.228.1473275651422; Wed, 07 Sep 2016 12:14:11 -0700 (PDT) MIME-Version: 1.0 Received: by 10.25.149.65 with HTTP; Wed, 7 Sep 2016 12:13:31 -0700 (PDT) In-Reply-To: References: From: Abhishek Girish Date: Wed, 7 Sep 2016 12:13:31 -0700 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: WHERE clause causing a ClassCastException on HBase tables To: Drill User List Content-Type: multipart/alternative; boundary=001a113ec220dc19e0053befb737 --001a113ec220dc19e0053befb737 Content-Type: text/plain; charset=UTF-8 Hello Ki, You might not be receiving replies (attempting anyway). Your question did get a response - pasting below for your reference. ---------- Forwarded message ---------- From: rahul challapalli Date: Thu, Sep 1, 2016 at 11:09 AM Subject: Re: WHERE clause causing a ClassCastException on HBase tables To: dev 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 On Wed, Sep 7, 2016 at 11:01 AM, Ki Kang wrote: > I tried dev@drill.apache.org, but got no > response, so I am hoping that user@drill.apache.org ser@drill.apache.org> will be able to help out. > -------------------------------------------------------- > Can someone help or point me to where I can maybe get some help? > > 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 > > > --001a113ec220dc19e0053befb737--