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