Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
1 Reply
Anonymous
Not applicable
Author

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