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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
