Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id F2F9B17631 for ; Fri, 9 Jan 2015 02:26:11 +0000 (UTC) Received: (qmail 68988 invoked by uid 500); 9 Jan 2015 02:26:13 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 68927 invoked by uid 500); 9 Jan 2015 02:26:13 -0000 Mailing-List: contact dev-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 dev@drill.apache.org Received: (qmail 68910 invoked by uid 99); 9 Jan 2015 02:26:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Jan 2015 02:26:12 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW X-Spam-Check-By: apache.org Received-SPF: error (athena.apache.org: local policy) Received: from [209.85.216.170] (HELO mail-qc0-f170.google.com) (209.85.216.170) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Jan 2015 02:26:07 +0000 Received: by mail-qc0-f170.google.com with SMTP id x3so6161534qcv.1 for ; Thu, 08 Jan 2015 18:25:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:from:date:message-id :subject:to:content-type; bh=wPs4maYPdfjj6RxXLrfH3deHmBBwe2sk2y0BKYS03bY=; b=qQOjruS3Or1bChtZO125YuLZrV4ebSXz/BcMcEX7wB7/29UQ6/loXkREzrMSw437RY CCHmITMeKEW77mAs21+rOkXNIevF/ABwExnIHbduPC4ICzefOe0AGKDw5O7Yd9FfApYN bW/q9r8YoVnKqfLEPlYtrDctq/eCk0RISEu4GXEn7MipnSpD+pzONfQ4XTza9DeIhTLp t+iL5IDVxasody8SgPmCqVWHWUkf3LLMGIPGZPMJL8mWQqH8kN8Yfup/YyH82zx36aix XLXrOxwIg/a5IA8hGf9RZwboeWKnYRHHBoW4alX0iiKTMQfYgIx9K6sjsBg5yzaXitW+ QexA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:sender:in-reply-to:references:from :date:message-id:subject:to:content-type; bh=wPs4maYPdfjj6RxXLrfH3deHmBBwe2sk2y0BKYS03bY=; b=NYnzbYx23SDaYZjhoZ2SWdop0kkezGikYmafgpcOnBDFR8QfYKRVJandVUGCx2+4Z5 pIHGhi/CR6kebypY5JSnnQdhl74QiVlj5FqnNa6FWVbjF2VPyfw0ATItkxSaUD7FTcSb /ofBs/63UUhh7fbiwgWczi65MaIw5xxPBvlQ2kHGOY+PZm6/kllPpiJ9sQy+grIyW0Mp qc0vYyPVvJCL7CSwpvWh8hp+CbEIU63txu+5Eil/mkUqNmJ7PWOIEIaPFMXLE9I7m/Wj TSxzGduR7MWIZQrxemAt/tFIx0AMVdghmuMSbe5z+QmKkvTzZKvvA1mWKic5mNwC8nZh ZzFg== X-Gm-Message-State: ALoCoQmLjROVT160uWR9NYwzFxoJtdJ+g6qB9lAFW5PnNKj+Lr2StNUIDYmToErWUW/z8uUJOdF9 X-Received: by 10.224.3.137 with SMTP id 9mr22767181qan.64.1420770326559; Thu, 08 Jan 2015 18:25:26 -0800 (PST) MIME-Version: 1.0 Sender: abhishek@abhishekgirish.info Received: by 10.96.238.37 with HTTP; Thu, 8 Jan 2015 18:25:06 -0800 (PST) X-Originating-IP: [50.201.157.66] In-Reply-To: References: From: Abhishek Girish Date: Thu, 8 Jan 2015 18:25:06 -0800 X-Google-Sender-Auth: mgbZ5oAmD9AF1BTjE2QebNV9WLU Message-ID: Subject: Re: Support for Text Datatype To: dev@drill.apache.org Content-Type: multipart/alternative; boundary=001a11c2480a9f5132050c2ede1b X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2480a9f5132050c2ede1b Content-Type: text/plain; charset=UTF-8 Then there is a high chance I might have used it with Postgres instead. Like you said, the documentation needs to be updated. But I shall wait for your confirmation. Thanks! On Thu, Jan 8, 2015 at 6:18 PM, Aman Sinha wrote: > Text type fails validation in Calcite/Optiq so I don't think it was ever > supported. There's a good chance the documentation needs to be > updated..but let me confirm that by tomorrow. > > On Thu, Jan 8, 2015 at 4:29 PM, Abhishek Girish wrote: > > > Hi all, > > > > The documentation ( > > https://cwiki.apache.org/confluence/display/DRILL/Data+Types) lists Text > > as > > a supported data type in Drill and I vaguely remember using the same > > sometime before in my CTAS scripts. > > > > As of now, my queries with an explicit cast to Text fails complaining > > "*Unknown > > datatype name 'TEXT' "* > > > > Can someone confirm if Text is indeed a supported data type and the > current > > behavior is a bug? Or if it unsupported and the documentation needs to be > > corrected. I'll file a JIRA accordingly. > > > > Regards, > > Abhishek > > > --001a11c2480a9f5132050c2ede1b--