Not able to connect hive from Talend.

One Star

Not able to connect hive from Talend.

Connection failure. You must change the Database Settings.
  java.sql.SQLException: java.lang.reflect.InvocationTargetException
      at org.talend.metadata.managment.hive.EmbeddedHiveDataBaseMetadata.getTables(EmbeddedHiveDataBaseMetadata.java:314)
      at org.talend.metadata.managment.hive.EmbeddedHiveDataBaseMetadata.checkConnection(EmbeddedHiveDataBaseMetadata.java:132)
      at org.talend.metadata.managment.connection.manager.HiveConnectionManager.checkConnection(HiveConnectionManager.java:378)
      at org.talend.metadata.managment.repository.ManagerConnection.checkHiveConnection(ManagerConnection.java:163)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$30.runWithCancel(DatabaseForm.java:2665)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$30.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
  Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.talend.core.utils.ReflectionUtils.invokeMethod(ReflectionUtils.java:166)
      at org.talend.metadata.managment.hive.EmbeddedHiveDataBaseMetadata.getTables(EmbeddedHiveDataBaseMetadata.java:301)
      ... 9 more
  Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out)
      at org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:1147)
      ... 15 more
  Caused by: MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out)
      at org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:1139)
      at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTables(HiveMetaStoreClient.java:1134)
      at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.getTables(SessionHiveMetaStoreClient.java:157)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:90)
      at com.sun.proxy.$Proxy39.getTables(Unknown Source)
      at org.apache.hadoop.hive.ql.metadata.Hive.getTablesByPattern(Hive.java:1145)
      ... 15 more
Employee

Re: Not able to connect hive from Talend.

Hello Madhu,
Try changing your Hive connection from embedded to standalone I found the answer from the link below. That should resolve your issue.