Return-Path: 
 <dev-return-114715-apmail-hive-dev-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-dev-archive@www.apache.org
Delivered-To: apmail-hive-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 28585C8B0
	for <apmail-hive-dev-archive@www.apache.org>;
 Sat, 15 Nov 2014 18:43:39 +0000 (UTC)
Received: (qmail 47931 invoked by uid 500); 15 Nov 2014 18:43:33 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 47854 invoked by uid 500); 15 Nov 2014 18:43:33 -0000
Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@hive.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@hive.apache.org>
List-Post: <mailto:dev@hive.apache.org>
List-Id: <dev.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list dev@hive.apache.org
Received: (qmail 47843 invoked by uid 500); 15 Nov 2014 18:43:33 -0000
Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org
Received: (qmail 47840 invoked by uid 99); 15 Nov 2014 18:43:33 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Nov 2014 18:43:33 +0000
Date: Sat, 15 Nov 2014 18:43:33 +0000 (UTC)
From: "G Lingle (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12755620.1416076772000.509332.1416077013617@Atlassian.JIRA>
In-Reply-To: <JIRA.12755620.1416076772000@Atlassian.JIRA>
References: <JIRA.12755620.1416076772000@Atlassian.JIRA>
 <JIRA.12755620.1416076772359@arcas>
Subject: [jira] [Updated] (HIVE-8889) JDBC Driver ResultSet.getXXXXXX(String
 columnLabel) methods Broken
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


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

G Lingle updated HIVE-8889:
---------------------------
    Description: 
Using hive-jdbc-0.13.1-cdh5.2.0.jar.

All of the get-by-column-label methods of HiveBaseResultSet are now broken.  They don't take just the column label as they should.  Instead you have to pass in <table name>.<column name>.  This requirement doesn't conform to the java ResultSet API which specifies:

"columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column"

Looking at the code, it seems that the problem is that findColumn() method is looking in normalizedColumnNames instead of the columnNames.

BTW, Another annoying issue with the code is that the SQLException thrown gives no indication of what the problem is.  It should at least say that the column name wasn't found in the description string.


  was:
Using hive-jdbc-0.13.1-cdh5.2.0.jar.

All of the get-by-column-label methods of HiveBaseResultSet are now broken.  They don't take just the column label as they should.  Instead you have to pass in <table name>.<column name>.  This requirement doesn't conform to the java ResultSet API which specifies:

"columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column"

Looking at the code, it seems that the findColumn() method is looking in normalizedColumnNames instead of the columnNames.

BTW, Another annoying issue with the code is that the SQLException thrown gives no indication of what the problem is.  It should at least say that the column name wasn't found.



> JDBC Driver ResultSet.getXXXXXX(String columnLabel) methods Broken
> ------------------------------------------------------------------
>
>                 Key: HIVE-8889
>                 URL: https://issues.apache.org/jira/browse/HIVE-8889
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.1
>            Reporter: G Lingle
>            Priority: Critical
>
> Using hive-jdbc-0.13.1-cdh5.2.0.jar.
> All of the get-by-column-label methods of HiveBaseResultSet are now broken.  They don't take just the column label as they should.  Instead you have to pass in <table name>.<column name>.  This requirement doesn't conform to the java ResultSet API which specifies:
> "columnLabel - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column"
> Looking at the code, it seems that the problem is that findColumn() method is looking in normalizedColumnNames instead of the columnNames.
> BTW, Another annoying issue with the code is that the SQLException thrown gives no indication of what the problem is.  It should at least say that the column name wasn't found in the description string.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)