topic Re: Connection Dataproc in Qlik Replicate

Connection Dataproc

ELHARRAS — Tue, 26 Mar 2024 15:43:14 GMT

Bonjour,

Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate.

Erreur veut dire que l'adresse host et le numéro du port pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK .

Cordialement.

Re: Connection Dataproc

john_wang — Wed, 27 Mar 2024 07:11:02 GMT

Google translate:

Connection Dataproc
Good morning,

I can't connect to the Dataproc cluster from Qlik replicate.

More Details
SYS-E-HTTPFAIL, RetCode: SQL_ERROR SqlState: HY000 NativeError: 1110
Message: [Cloudera][DriverSupport] (1110) Unexpected response received
from server. Please ensure the server host and port specified for the
connection are correct and confirm if SSL should be enabled for the
connection..
SYS,GENERAL_EXCEPTION,RetCode: SQL_ERROR SqlState: HY000 NativeError:
1110 Message: [Cloudera][DriverSupport] (1110) Unexpected response
received from server. Please ensure the server host and port specified for the
connection are correct and confirm if SSL should be enabled for the
connection.

Error means that the host address and the port number to connect to Hive which blocks the config for cloud Storage is OK.

Sincerely.

Re: Connection Dataproc

john_wang — Wed, 27 Mar 2024 07:15:48 GMT

Hello @ELHARRAS ,

Welcome to Qlik Community forum and thanks for reaching out here!

Looks to me this is a pure connectivity issue. Would you please troubleshoot the issue by:

1. Define a 64-bit ODBC DSN in Qlik Replicate Server and test the connectivity by using the DSN

Make sure the proper server IP Address/ Hostname and port number are correctly input.

2. have you checked with the Cloudera Hadoop support?
I have googled the below knowledge base articles regarding to the same error from Cloudera but I don't have Cloudera access, so I don't have a view. Hope you can check.

ERROR: "Unexpected response received from server" when connection from an ODBC client fails

Hope this helps.

John.