DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
nimcurry
Participant



Joined: 02 Nov 2015
Posts: 4
Location: toronto
Points: 55

Post Posted: Mon Nov 02, 2015 10:50 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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:

Code:
[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

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?
TNZL_BI



Group memberships:
Premium Members

Joined: 20 Aug 2012
Posts: 23
Location: NZ
Points: 239

Post Posted: Sun Apr 23, 2017 3:28 pm Reply with quote    Back to top    

Yes it is and we have just managed a connection to the Hive database using the ODBC stage and Hive Connector
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours