From user-return-7197-apmail-drill-user-archive=drill.apache.org@drill.apache.org Mon Dec 5 01:56:04 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 9EA8219437 for ; Mon, 5 Dec 2016 01:56:04 +0000 (UTC) Received: (qmail 87858 invoked by uid 500); 5 Dec 2016 01:56:04 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 87806 invoked by uid 500); 5 Dec 2016 01:56:04 -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 87790 invoked by uid 99); 5 Dec 2016 01:56:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Dec 2016 01:56:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 188561AACA2 for ; Mon, 5 Dec 2016 01:56:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.121 X-Spam-Level: X-Spam-Status: No, score=-0.121 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 3swLwxbu7R3G for ; Mon, 5 Dec 2016 01:56:02 +0000 (UTC) Received: from mail-qt0-f169.google.com (mail-qt0-f169.google.com [209.85.216.169]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 638515F2EF for ; Mon, 5 Dec 2016 01:56:01 +0000 (UTC) Received: by mail-qt0-f169.google.com with SMTP id p16so300641002qta.0 for ; Sun, 04 Dec 2016 17:56:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:content-transfer-encoding:mime-version:subject:date:references :to:in-reply-to:message-id; bh=J0R1KSB+xYQEjrBPH7MKeC5Zg8Sf7eGLtyxFJmcEOA0=; b=ZkGGFY29bQAG3EFFSsmU6naf7Ow39PXPX2PmwDWo+Hfk1xawuQHadiTpM7kylscIXa Oh1fI4vZj8APdhTmSdYUHIyo+W3ZPMomrOjmTzV2K/+3IHUqYkWm4jgXuwqaQSoX+B7L KwWTZkJ/ENzMcbWiBGn8JRxGQSuTJ4KkoJKn1Sg3Ep+gVbXVUqwGN9Xj/qnK9q//Xwhw WgkmSQ4aDVJuVd5f/Jp5kRkCbWdtAwpeQuJMuPicu6f+nhJlVsg1E9Npi4F1Xi8PcXOH gvbYwTH8soCTmE4xJcOz4N+aw3e+XUe59F2GQIX5g7tWbCU7t5/UikyR+zWdxC0sTPin 8BQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:date:references:to:in-reply-to:message-id; bh=J0R1KSB+xYQEjrBPH7MKeC5Zg8Sf7eGLtyxFJmcEOA0=; b=eryq9rJqYjxCwki1JXvgmOiAV76sgt5c5a3F5sGkGLne4xtvcH2IS3FxJz9rRf+vJm aPYfLTJkmNrv8tp0M5KzL0mXgmWaQmRxLDmISgoOYZ0KFt8pdrI02BRW54/iU28sUMYv IvQz1O30ANMrRsc2o068ExFB3SYXylvtCUX04irmwa1wLomC9Ft4a0QK4f8yxKPA/OHd AKxCv7UwV8wUaZHHpfoqb3CwKLZhnmg9xe/u+53oolx5AcNaE8zJikAKzmmRwwDCZ1i4 0LT2MFwkRk5AtcAVzv31HtU6ZwbCEmyfUXRXbK2QvwWPDsLAVuoUQc+6tnDToQT7aEXF +08g== X-Gm-Message-State: AKaTC00YMO1Tquchcwy10MOMRiYpENRVGWb5h8lgOHGBIbX0HYNiru66kVRIVzycsYjAAQ== X-Received: by 10.200.44.123 with SMTP id e56mr47676247qta.122.1480902958226; Sun, 04 Dec 2016 17:55:58 -0800 (PST) Received: from charless-mbp-2.fios-router.home (pool-108-3-144-183.bltmmd.fios.verizon.net. [108.3.144.183]) by smtp.gmail.com with ESMTPSA id f36sm8280744qkf.43.2016.12.04.17.55.57 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 04 Dec 2016 17:55:57 -0800 (PST) From: Charles Givre Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 10.1 \(3251\)) Subject: Re: Table Metadata Question Date: Sun, 4 Dec 2016 20:55:55 -0500 References: <70AB0F3B-C226-4449-87B3-104022103D71@gmail.com> To: user@drill.apache.org In-Reply-To: Message-Id: X-Mailer: Apple Mail (2.3251) That=E2=80=99s exactly what I was looking for. I=E2=80=99m working on = an adapter for a BI tool. Is there a way also see what type of storage = plugin is being used? > On Dec 4, 2016, at 20:54, Aman Sinha wrote: >=20 > Charles, > Drill does not have a metastore for tables, so unless you have defined = a > view with CAST or are querying Hive tables (Hive has a metastore), = the > column types are determined at run-time. Have you tried the typeof() > function ? > SELECT typeof(column) FROM dfs.`data.json` LIMIT 1; >=20 >=20 > On Sun, Dec 4, 2016 at 8:47 AM, Charles Givre = wrote: >=20 >> Hello all, >> I=E2=80=99m trying to figure out if there is some way to determine = what types of >> columns a given data source contains. It looks like this should = exist in >> the INFORMATION_SCHEMA somewhere, but I=E2=80=99m not clear how to do = it. >>=20 >> For instance, let=E2=80=99s say that I have a file called data.json. = I could >> execute: >> SELECT * >> FROM dfs.`data.json` >> LIMIT 0 >> and get the column names, but is there some way to get at the data = types >> for these columns? >> TIA, >> =E2=80=94 Charles