Cloud Pak for Data

 View Only
  • 1.  Issue in connecting hive in ICP4D through Hive JDBC/ Hive JDBC-HDP

    Posted Fri June 21, 2019 11:11 AM
    Hi,
    I am trying to connect to hive, which is located in hadoop environment (masternode) tpysydhdpm101.sl.bluecloud.ibm.com
    I have registered an edgenode(tpysydhdpe201.sl.bluecloud.ibm.com) of the same hadoop environment in my ICP4D cluster.
    From this edgenode i am able to access hive
    From my ICP4D master-node, i am able to telnet tpysydhdpm101.sl.bluecloud.ibm.com to port 10000
    Details and configuration properties of hive are:

    I am trying to use the same information to configure and connect hive in ICP4D using both Hive-JDBC and Hive-JDBC HDP
    For both the configuration i am getting the same error-message that is
    "Test connection failed - The connector failed to connect to the data source. The reported error is: java.sql.SQLNonTransientConnectionException: [IBM][Hive JDBC Driver]Error establishing socket to host and port: tpysydhdpm101.sl.bluecloud.ibm.com:10000. Reason: Connection timed out (Connection timed out)"
    Also i have added hadoop hostname(10.139.33.39  tpysydhdpm101.sl.bluecloud.ibm.com )
    in my util-api pods  '/etc/hostname' as well as to the  '/etc/hosts' of ICP4D masternode
    I am not sure if i am giving the wrong 'hostname' or the 'port',  or what should be the port in my case
    should the hostname of the hive be the same as the one registered in the ICP4D.

    Need some information on this as i am facing this issue for quite a long time.

    ------------------------------
    Amit Alvin Daniel Daniel
    ------------------------------

    #CloudPakforDataGroup


  • 2.  RE: Issue in connecting hive in ICP4D through Hive JDBC/ Hive JDBC-HDP

    Posted Tue July 23, 2019 11:35 AM
    Here are some instructions on connecting hive
    https://www.ibm.com/support/knowledgecenter/en/SSQNUZ_2.1.0/com.ibm.icpdata.doc/zen/admin/hive-kerb-connection.html

    ------------------------------
    ADAM NOWOTARSKI
    ------------------------------