Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 13789 invoked from network); 3 Feb 2010 08:31:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Feb 2010 08:31:56 -0000 Received: (qmail 6486 invoked by uid 500); 3 Feb 2010 08:31:55 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 6436 invoked by uid 500); 3 Feb 2010 08:31:55 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 6427 invoked by uid 99); 3 Feb 2010 08:31:54 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Feb 2010 08:31:54 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [194.151.176.130] (HELO hq.ebuddy.com) (194.151.176.130) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Feb 2010 08:31:46 +0000 Received: from [192.168.4.150] ([194.151.176.132]) by hq.ebuddy.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 3 Feb 2010 09:31:05 +0100 Message-ID: <4B693449.4010706@ebuddy.com> Date: Wed, 03 Feb 2010 09:31:05 +0100 From: Bennie Schut User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: hive-user@hadoop.apache.org Subject: Some additions to the hive jdbc driver. Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 03 Feb 2010 08:31:05.0368 (UTC) FILETIME=[3A0B9180:01CAA4AB] I've been using the hive jdbc driver more and more and was missing some functionality which I added HiveDatabaseMetaData.getTables Using "show tables" to get the info from hive. HiveDatabaseMetaData.getColumns Using "describe tablename" to get the columns. This makes using something like SQuirreL a lot nicer since you have the list of tables and just click on the content tab to see what's in the table. I also implemented HiveResultSet.getObject(String columnName) so you call most get* methods based on the column name. Is it worth making a patch for this?