gabydreckschmidt
commented
5 years ago @tumblewind I spoke with the development team and it seems that you haven't followed the instructions in the documentation completely. You are connecting to 10001 port instead of 8443. Also the JDBC URL is not complete.
- Please see https://cloud.ibm.com/docs/services/AnalyticsEngine?topic=AnalyticsEngine-working-with-hive#connecting-to-the-hive-server for the port numbers.
- See https://cloud.ibm.com/docs/services/AnalyticsEngine?topic=AnalyticsEngine-retrieve-endpoints to ensure you have the correct JDBC URL.
tumblewind
Connection failed on host chs-vmb-469-mn00xxxxx.cloud:10001 (Traceback (most recent call last): File "/var/lib/ambari-agent/cache/stacks/HDP/3.0/services/SPARK2/package/scripts/alerts/alert_spark2_thrift_port.py", line 147, in execute Execute(cmd, user=sparkuser, path=[beeline_cmd], timeout=CHECK_COMMAND_TIMEOUT_DEFAULT) File "/usr/lib/ambari-agent/lib/resource_management/core/base.py", line 166, in init self.env.run() File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 160, in run self.run_action(resource, action) File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 124, in run_action provider_action() File "/usr/lib/ambari-agent/lib/resource_management/core/providers/system.py", line 263, in action_run returns=self.resource.returns) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 72, in inner result = function(command, kwargs) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 102, in checked_call tries=tries, try_sleep=try_sleep, timeout_kill_strategy=timeout_kill_strategy, returns=returns) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 150, in _call_wrapper result = _call(command, kwargs_copy) File "/usr/lib/ambari-agent/lib/resource_management/core/shell.py", line 314, in _call raise ExecutionFailed(err_msg, code, out, err) ExecutionFailed: Execution of '! /usr/hdp/current/spark2-client/bin/beeline -u 'jdbc:hive2://chs-vmb-469-mn002.us-south.ae.appdomain.cloud:10001/default;transportMode=http' -e '' 2>&1| awk '{print}'|grep -i -e 'Connection refused' -e 'Invalid URL' -e 'Error: Could not open'' returned 1. Error: Could not open client transport with JDBC Uri: jdbc:hive2://chs-vmb-469-mn002.us-south.ae.appdomain.cloud:10001/default;transportMode=http: Could not create http connection to jdbc:hive2://chs-vmb-469-mn002.xxxxappdomain.cloud:10001/default;transportMode=http. HTTP Response code: 405 (state=08S01,code=0) Error: Could not open client transport with JDBC Uri: jdbc:hive2://chs-vmb-469-mn002.xxxxappdomain.cloud:10001/default;transportMode=http: Could not create http connection to jdbc:hive2://chs-vmb-469-mn002.us-south.ae.appdomain.cloud:10001/default;transportMode=http. HTTP Response code: 405 (state=08S01,code=0) )