Not able to connect hive from Talend.

Anonymous — Sat, 16 Nov 2024 10:50:18 GMT

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

Re: Not able to connect hive from Talend.

Anonymous — Fri, 29 Jan 2016 23:45:59 GMT

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

topic Re: Not able to connect hive from Talend. in Talend Studio

Not able to connect hive from Talend.

Re: Not able to connect hive from Talend.