unable to create hive table using TAC schedule.

[RAJ6]

Hi Folks,

I am planning to create a hive table using tHiveCreateTable in talend. it's working fine. While scheduling the same job in TAC, I faced the issue. I have mentioned error information below. Kindly share your information.

[ERROR]: org.apache.hive.jdbc.Utils - Unable to read HiveServer2 configs from ZooKeeper

[FATAL]: smartnet.z_309_0_1.z_309 - tHiveCreateTable_1 Could not open client transport for any of the Server URI's in ZooKeeper: java.net.UnknownHostException: node2.hadoop.com

java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: java.net.UnknownHostException:   node2.hadoop.com

at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:217)

at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:155)

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 smartnet.z_309_0_1.z_309.tHiveCreateTable_1Process(z_309.java:502)

at smartnet.z_309_0_1.z_309.runJobInTOS(z_309.java:961)

at smartnet.z_309_0_1.z_309.main(z_309.java:779)

[vapukov]

Hi,

in most of cases when it "works here, but not works there" 🙂

first what need to check connections from TAC (Job Server) to HDFS cluster at least for ports 10000 and 2181

plus ping from TAC (JobServer) your cluster nodes, like - node2.hadoop.com 

it possible you have defined ip for this hosts in hosts file, but not in hosts on TAC (Job) Server