connection issues between hive and datastage 11.3.1
Posted: Mon Nov 02, 2015 10:50 am
I am trying to connect to a hive database on a edge node (residing on another linux server secured with Keberos protocol). Following is my dsn connection parameters in .odbc.ini file:
and following is the error i got:
SQLSTATE = 08001
NATIVE ERROR = 0
MSG = [IBM(DataDirect OEM)][ODBC Apache Hive Wire Protocol driver]Client unable to establish connection
I am just wondering if it is even possible at all to connect to a hive database using a user name/password?
Code: Select all
[EDL_Hive]
Driver=/opt/IBM/InformationServer11-3/Server/branded_odbc/lib/VMhive00.so
Description=DataDirect Apache Hive Wire Protocol
ArraySize=16384
AuthenticationMethod=1
Database=ISL_DB
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
GSSClient=native
HostName=10.1.21.45
LoginTimeout=30
LogonID=ndeshpande
MaxVarcharSize=8192
Password=
PortNumber=10000
ProxyUser=
RemoveColumnQualifiers=0
ServicePrincipalName=
StringDescribeType=12
TransactionMode=0
UseNativeCatalogFunctions=0
UseCurrentSchema=0
WireProtocolVersion=thrift
SQLSTATE = 08001
NATIVE ERROR = 0
MSG = [IBM(DataDirect OEM)][ODBC Apache Hive Wire Protocol driver]Client unable to establish connection
I am just wondering if it is even possible at all to connect to a hive database using a user name/password?