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 EE9ED18F16 for ; Wed, 17 Feb 2016 01:31:20 +0000 (UTC) Received: (qmail 90812 invoked by uid 500); 17 Feb 2016 01:31:18 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 90670 invoked by uid 500); 17 Feb 2016 01:31:18 -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 90247 invoked by uid 99); 17 Feb 2016 01:31:18 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 Feb 2016 01:31:18 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 467732C1F5D for ; Wed, 17 Feb 2016 01:31:18 +0000 (UTC) Date: Wed, 17 Feb 2016 01:31:18 +0000 (UTC) From: "N Campbell (JIRA)" To: dev@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-4391) browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 N Campbell created DRILL-4391: --------------------------------- Summary: browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables Key: DRILL-4391 URL: https://issues.apache.org/jira/browse/DRILL-4391 Project: Apache Drill Issue Type: Bug Components: Metadata Affects Versions: 1.4.0 Reporter: N Campbell Apache Drill has storage defined to access a Postgres database A schema in the database has several tables which either have indexes, primary keys, foreign keys or combination of them all. When SQLSquirrel presents metadata from the Drill JDBC driver the list of tables will include entries which correspond to the indexes, primary or foreign keys in the schema. The implication being that non-standard JDBC metadata methods to obtain information is being used. -- This message was sent by Atlassian JIRA (v6.3.4#6332)