'Bad URL format. Hostname not found in authority part of the url' while running a Hadoop Job that includes tHivexxx components

Problem Description

A Job that includes tHivexxxx components and uses Hadoop MapR version 5.2 fails. You get this error:

Exception in component tHiveConnection_1 (hivetest) 
java.sql.SQLException: java.lang.IllegalArgumentException: Bad URL format. Hostname not found in authority part of the url: DEMO-MAPR-NODE3:5181,DEMO-MAPR-NODE2:5181,DEMO-MAPR-NODE1:5181. Are you missing a '/' after the hostname ? 
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:136) 
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105) 
at java.sql.DriverManager.getConnection(DriverManager.java:664) 
at java.sql.DriverManager.getConnection(DriverManager.java:247) 
at etl_3_1.hivetest_0_1.hivetest.tHiveConnection_1Process(hivetest.java:627) 
at etl_3_1.hivetest_0_1.hivetest.runJobInTOS(hivetest.java:1251) 
at etl_3_1.hivetest_0_1.hivetest.main(hivetest.java:932) 
Caused by: java.lang.IllegalArgumentException: Bad URL format. Hostname not found in authority part of the url: DEMO-MAPR-NODE

 

Root Cause

If you create a connection using the incorrect version of Hadoop, for example, selecting MapR 4.1 when the actual MapR version is 5.2, Talend uses the Hive JAR based on the incorrect Hadoop version for the metadata connection.

 

Solution

Update the metadata connection to use the correct Hadoop version.

Version history
Revision #:
5 of 5
Last update:
‎02-26-2019 03:48 AM
Updated by: