You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "pradoshsahoo2021 (via GitHub)" <gi...@apache.org> on 2023/02/13 10:23:33 UTC

[GitHub] [hop] pradoshsahoo2021 commented on issue #2057: [Bug]: HIVE2 is not recognised in Apache Hop

pradoshsahoo2021 commented on issue #2057:
URL: https://github.com/apache/hop/issues/2057#issuecomment-1427688852

   @hansva With Apache HOP 2.3 version, I am not able to connect to HIVE database. Is it possible to have a call to discuss this issue?
   
   Error:
   Error connecting to database [HIVE] :org.apache.hop.core.exception.HopDatabaseException: 
   Error occurred while trying to connect to the database
   
   Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
   Could not open client transport with JDBC Uri: jdbc:hive2://host:443/default?hive.exec.parallel=true&tez.am.resource.memory.mb=12288&transportMode=http&AuthMech=3&tez.queue.name=default&tez.grouping.max-size=16777216&mapreduce.input.fileinputformat.split.minsize=1048576&hive.fetch.task.conversion=none&AllowAllHostNames=1&UseNativeQuery=1&mapreduce.input.fileinputformat.split.maxsize=16777216&SSLKeyStorePwd=changeit&ssl=1&httpPath=gateway/cdp-proxy-api/hive&SSLKeyStore=abc.truststore&hive.tez.container.size=10480&tez.grouping.min-size=1048576&AllowSelfSignedCerts=1: Socket is closed by peer.
   
   
   org.apache.hop.core.exception.HopDatabaseException: 
   Error occurred while trying to connect to the database
   
   Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
   Could not open client transport with JDBC Uri: jdbc:hive2://host:443/default?hive.exec.parallel=true&tez.am.resource.memory.mb=12288&transportMode=http&AuthMech=3&tez.queue.name=default&tez.grouping.max-size=16777216&mapreduce.input.fileinputformat.split.minsize=1048576&hive.fetch.task.conversion=none&AllowAllHostNames=1&UseNativeQuery=1&mapreduce.input.fileinputformat.split.maxsize=16777216&SSLKeyStorePwd=changeit&ssl=1&httpPath=gateway/cdp-proxy-api/hive&SSLKeyStore=abc.truststore&hive.tez.container.size=10480&tez.grouping.min-size=1048576&AllowSelfSignedCerts=1: Socket is closed by peer.
   
   
   	at org.apache.hop.core.database.Database.normalConnect(Database.java:375)
   	at org.apache.hop.core.database.Database.connect(Database.java:306)
   	at org.apache.hop.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:47)
   	at org.apache.hop.core.database.DatabaseFactory.getConnectionTestResults(DatabaseFactory.java:72)
   	at org.apache.hop.core.database.DatabaseMeta.testConnectionSuccess(DatabaseMeta.java:2053)
   	at org.apache.hop.ui.core.database.DatabaseMetaEditor.testConnection(DatabaseMetaEditor.java:857)
   	at org.apache.hop.ui.core.database.DatabaseMetaEditor.test(DatabaseMetaEditor.java:744)
   	at org.apache.hop.ui.core.database.DatabaseMetaEditor.lambda$createButtonsForButtonBar$6(DatabaseMetaEditor.java:912)
   	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
   	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4251)
   	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1066)
   	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4068)
   	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3645)
   	at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:464)
   	at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:351)
   Caused by: org.apache.hop.core.exception.HopDatabaseException: 
   Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
   Could not open client transport with JDBC Uri: jdbc:hive2://host:443/default?hive.exec.parallel=true&tez.am.resource.memory.mb=12288&transportMode=http&AuthMech=3&tez.queue.name=default&tez.grouping.max-size=16777216&mapreduce.input.fileinputformat.split.minsize=1048576&hive.fetch.task.conversion=none&AllowAllHostNames=1&UseNativeQuery=1&mapreduce.input.fileinputformat.split.maxsize=16777216&SSLKeyStorePwd=changeit&ssl=1&httpPath=gateway/cdp-proxy-api/hive&SSLKeyStore=abc.truststore&hive.tez.container.size=10480&tez.grouping.min-size=1048576&AllowSelfSignedCerts=1: Socket is closed by peer.
   
   	at org.apache.hop.core.database.Database.connectUsingClass(Database.java:470)
   	at org.apache.hop.core.database.Database.normalConnect(Database.java:360)
   	... 14 more
   Caused by: java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://host:443/default?hive.exec.parallel=true&tez.am.resource.memory.mb=12288&transportMode=http&AuthMech=3&tez.queue.name=default&tez.grouping.max-size=16777216&mapreduce.input.fileinputformat.split.minsize=1048576&hive.fetch.task.conversion=none&AllowAllHostNames=1&UseNativeQuery=1&mapreduce.input.fileinputformat.split.maxsize=16777216&SSLKeyStorePwd=changeit&ssl=1&httpPath=gateway/cdp-proxy-api/hive&SSLKeyStore=abc.truststore&hive.tez.container.size=10480&tez.grouping.min-size=1048576&AllowSelfSignedCerts=1: Socket is closed by peer.
   	at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:256)
   	at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
   	at org.apache.hop.core.database.DelegatingDriver.connect(DelegatingDriver.java:45)
   	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
   	at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
   	at org.apache.hop.core.database.Database.connectUsingClass(Database.java:454)
   	... 15 more
   Caused by: org.apache.thrift.transport.TTransportException: Socket is closed by peer.
   	at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:184)
   	at org.apache.thrift.transport.TTransport.readAll(TTransport.java:109)
   	at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:151)
   	at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:272)
   	at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:39)
   	at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:343)
   	at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:228)
   	... 20 more
   
   Hostname:	host
   Port:	443
   Database name:	default
   Url:	jdbc:hive2://host:443/default?hive.exec.parallel=true&tez.am.resource.memory.mb=12288&transportMode=http&AuthMech=3&tez.queue.name=default&tez.grouping.max-size=16777216&mapreduce.input.fileinputformat.split.minsize=1048576&hive.fetch.task.conversion=none&AllowAllHostNames=1&UseNativeQuery=1&mapreduce.input.fileinputformat.split.maxsize=16777216&SSLKeyStorePwd=changeit&ssl=1&httpPath=gateway/cdp-proxy-api/hive&SSLKeyStore=abc.truststore&hive.tez.container.size=10480&tez.grouping.min-size=1048576&AllowSelfSignedCerts=1
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org