[
https://issues.apache.org/jira/browse/HIVE-15814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16834366#comment-16834366
]
Dan Horne commented on HIVE-15814:
----------------------------------
Hi - I hope I'm not hijacking this thread, but I'm encountering a similar issue
using ODBC and Perl (i.e. some of the same errors in the OP's log), so I
thought it would be useful to add my "reproduceable" test here.
Strawberry Perl 5.28.1 in Windows Server 2012
Microsoft Hive ODBC Driver 2.01.09.1014
Apache Hive: 2.1.1-mapr-1901-r2
{quote}use strict;
use DBI;
use autodie;
my $dbh = DBI->connect(
'DBI:ODBC:DSN=<DSN>',
‘<UID>’,
'<PWD>',
{
RaiseError => 1,
PrintError => 0,
}
);
$dbh->do('set role admin;');
{quote}
Running it produces the error which were in the OP logs
{quote}DBD::ODBC::db do failed: [Microsoft][Hardy] (61) Server returned error
with no error message during operation: GetResultSetMetadata
TStatus.statusCode=ERROR_STATUS
TStatus.infoMessages="*java.lang.NullPointerException:null:16:15""org.apache.hive.service.cli.TableSchema:<init>:TableSchema.java:52""org.apache.hive.service.cli.TableSchema:<init>:TableSchema.java:59""org.apache.hive.service.cli.operation.SQLOperation:getResultSetSchema:SQLOperation.java:446""org.apache.hive.service.cli.operation.OperationManager:getOperationR
(SQL-HY000)
{quote}
Perhaps the error occurs because "set role admin" doesn't return a resultset.
Issuing regular SQL statements works fine
> ODBC - LOAD DATA - NullPointerException
> ---------------------------------------
>
> Key: HIVE-15814
> URL: https://issues.apache.org/jira/browse/HIVE-15814
> Project: Hive
> Issue Type: Bug
> Components: ODBC
> Affects Versions: 1.2.1
> Reporter: Pierre Villard
> Priority: Major
>
> Tested with :
> - Hive 1.2.1.2.4.0
> - Hive 1.2.1.2.5.3
> Information regarding ODBC access:
> - Aginity Workbench for Hadoop
> - Version 4.8.0.2551 (build 6/14/2016)
> - Microsoft Windows NT 6.1.7601 Service Pack 1 (64-bit)
> - DBMS Version: 1.2.1000.2.5.3.0-37 Apache Hive
> - Driver Used: Hive Native
> - ODBC Driver Signature: {Aginity Hive}
> Request executed:
> {noformat}
> LOAD DATA INPATH '/tmp/AYX170201a327cc8faf8e562f5eb86225dd1fbf57' INTO TABLE
> tmp.testpierre
> {noformat}
> Stacktrace available here:
> https://gist.github.com/pvillard31/9a08650f9a80ef0fa7e161d71c0d9e9b
> It seems to be specific to this driver shipped with Aginity studio. Same
> tests with Simba ODBC driver or HWX ODBC driver are working fine.
> I suppose the NPE could be handled in a proper way even though it seems to be
> related to some strange calls from ODBC driver.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
