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 C683C17CC8 for ; Fri, 13 Mar 2015 18:52:38 +0000 (UTC) Received: (qmail 5910 invoked by uid 500); 13 Mar 2015 18:52:38 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 5847 invoked by uid 500); 13 Mar 2015 18:52:38 -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 5798 invoked by uid 99); 13 Mar 2015 18:52:38 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Mar 2015 18:52:38 +0000 Date: Fri, 13 Mar 2015 18:52:38 +0000 (UTC) From: "Rahul Challapalli (JIRA)" To: dev@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (DRILL-2450) JDBC : DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Rahul Challapalli created DRILL-2450: ---------------------------------------- Summary: JDBC : DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set Key: DRILL-2450 URL: https://issues.apache.org/jira/browse/DRILL-2450 Project: Apache Drill Issue Type: Bug Components: Client - JDBC Reporter: Rahul Challapalli Assignee: Daniel Barclay (Drill) Priority: Blocker git.commit.id.abbrev=e92db23 DatabaseMetaData.getColumns is missing the 'COLUMN_SIZE' in the result set. This is also screwing up the order in which other fields are returned. Below is the column size returned by postgres for different data types. Though its specific to the data, I am just adding it here {code} int8 : 19 (this is a bigint column) bool:1 date:13 float8:17 (this is a double column) float8:17 (this is a float column) int4 : 10 time:15 timestamp : 29 varchar : 50 {code} Below are few things an analytic tool might use which are currently not working because of this : {code} DECIMAL_DIGITS : 9 NULLABLE : 11 REMARKS : 12 {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)