Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to connect qtp to hive
#1
Hi Sir/Mam,

I am trying to connect QTP to hive using the below code, but it is not working. Can any one suggest me how to connect

Set objConnection = CreateObject("ADODB.Connection")

Set objRecordSet = CreateObject("ADODB.Recordset")

objConnection.open "Driver = Hive;Database Port = 10000;Driver(JDBC) = Hortonworks HiveServer2 HDP 2.3;Database URL =                                     

        jdbc:hive2://g4t8346c.houston.hp.com:10000; Database Userid = srvc_eap_uat;Database Password = *********;"

 objRecordSet.open sqlQuery, objConnection 

 value = objRecordSet.fields.item(0)                

 msgbox Value
'
objRecordSet.Close
objConnection.Close
Set objConnection = Nothing
Set objRecordSet = Nothing


Thanks 
Anusha
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)