Return-Path: 
 <issues-return-2163-apmail-drill-issues-archive=drill.apache.org@drill.incubator.apache.org>
X-Original-To: apmail-drill-issues-archive@minotaur.apache.org
Delivered-To: apmail-drill-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id A323F10A23
	for <apmail-drill-issues-archive@minotaur.apache.org>;
 Mon, 23 Jun 2014 15:57:49 +0000 (UTC)
Received: (qmail 52697 invoked by uid 500); 23 Jun 2014 15:57:49 -0000
Delivered-To: apmail-drill-issues-archive@drill.apache.org
Received: (qmail 52674 invoked by uid 500); 23 Jun 2014 15:57:49 -0000
Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.incubator.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.incubator.apache.org>
List-Post: <mailto:issues@drill.incubator.apache.org>
List-Id: <issues.drill.incubator.apache.org>
Reply-To: dev@drill.incubator.apache.org
Delivered-To: mailing list issues@drill.incubator.apache.org
Received: (qmail 52665 invoked by uid 99); 23 Jun 2014 15:57:49 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jun 2014 15:57:49 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED,T_RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3)
    by apache.org (qpsmtpd/0.29) with SMTP; Mon, 23 Jun 2014 15:57:50 +0000
Received: (qmail 50016 invoked by uid 99); 23 Jun 2014 15:57:25 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jun 2014 15:57:25 +0000
Date: Mon, 23 Jun 2014 15:57:25 +0000 (UTC)
From: "Jacques Nadeau (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12723074.1403501906612.29371.1403539045290@arcas>
In-Reply-To: <JIRA.12723074.1403501906612@arcas>
References: <JIRA.12723074.1403501906612@arcas>
Subject: [jira] [Resolved] (DRILL-1056) Any query on
 INFORMATION_SCHEMA.TABLES is failing
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/DRILL-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau resolved DRILL-1056.
-----------------------------------

    Resolution: Invalid

TABLES is a reserved word in Drill.  As such, you need to write the query as select * from INFORMATION_SCHEMA.`TABLES`



> Any query on INFORMATION_SCHEMA.TABLES is failing
> -------------------------------------------------
>
>                 Key: DRILL-1056
>                 URL: https://issues.apache.org/jira/browse/DRILL-1056
>             Project: Apache Drill
>          Issue Type: Bug
>         Environment: sqlline
>            Reporter: B Anil Kumar
>
> SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE
> FROM INFORMATION_SCHEMA.TABLES
> is giving below exception:
> 0: jdbc:drill:> SELECT * FROM INFORMATION_SCHEMA.TABLES;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "39f544e0-14e4-4f83-ba00-36715708db10"
> endpoint {
>   address: "172.28.208.98"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < SqlParseException:[ Encountered ". TABLES" at line 1, column 33.
> Was expecting one of:
>     <EOF> 
>     "ORDER" ...
> :



--
This message was sent by Atlassian JIRA
(v6.2#6252)