You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by xatax <ro...@gmail.com> on 2020/07/13 03:58:34 UTC
jdbc connection not working.
I have attempted to connect to Kylin using jdbc driver for the following
Kylin versions 2.6, 3.0.2 and 3.1 and have been unable to make connection.
The driver files I have used are from the '$KYLIN_HOME/lib' directory:
for version 3.1: kylin-jdbc-3.1.0.jar, jcl-over-slf4j-1.7.21.jar,
slf4j-api-1.7.21.jar
for version 2.6.6: kylin-jdbc-2.6.6.jar
for version 3.0.2: kylin-jdbc-3.0.2.jar
Connection URL I am using:
jdbc:kylin://"EMR cluster hostname":7070/learn_kylin
JDBC Driver class: org.apache.kylin.jdbc.Driver
Will appreciate any insight into what might be going wrong.
Error logs:
38f9d37464b4% javac ky.java
38f9d37464b4% java ky
Connecting to database...
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
java.sql.SQLException:
org.apache.kylin.jdbc.shaded.org.apache.http.conn.HttpHostConnectException:
Connection to http://ec2-3-236-65-136.compute-1.amazonaws.com:7070 refused
at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:72)
at
org.apache.kylin.jdbc.KylinJdbcFactory.newConnection(KylinJdbcFactory.java:77)
at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at ky.main(ky.java:22)
Caused by:
org.apache.kylin.jdbc.shaded.org.apache.http.conn.HttpHostConnectException:
Connection to http://ec2-3-236-65-136.compute-1.amazonaws.com:7070 refused
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:190)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:294)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:643)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:479)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:906)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:805)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:784)
at org.apache.kylin.jdbc.KylinClient.connect(KylinClient.java:285)
at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:70)
... 5 more
Caused by: java.net.ConnectException: Operation timed out (Connection timed
out)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:606)
at
org.apache.kylin.jdbc.shaded.org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:127)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)
... 13 more
Goodbye!
38f9d37464b4% javac ky.java
38f9d37464b4% java ky
Connecting to database...
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
java.sql.SQLException: java.net.ConnectException: Operation timed out
(Connection timed out)
at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:72)
at
org.apache.kylin.jdbc.KylinJdbcFactory.newConnection(KylinJdbcFactory.java:77)
at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at ky.main(ky.java:22)
Caused by: java.net.ConnectException: Operation timed out (Connection timed
out)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:606)
at
org.apache.kylin.jdbc.shaded.org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:117)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:177)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:304)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:611)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:446)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:863)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57)
at org.apache.kylin.jdbc.KylinClient.connect(KylinClient.java:285)
at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:70)
... 5 more
Goodbye!
38f9d37464b4% java ky
Connecting to database...
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
java.sql.SQLException: java.net.ConnectException: Operation timed out
(Connection timed out)
at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:72)
at
org.apache.kylin.jdbc.KylinJdbcFactory.newConnection(KylinJdbcFactory.java:77)
at
org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at ky.main(ky.java:22)
Caused by: java.net.ConnectException: Operation timed out (Connection timed
out)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:606)
at
org.apache.kylin.jdbc.shaded.org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:117)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:177)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:304)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:611)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:446)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:863)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
at
org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57)
at org.apache.kylin.jdbc.KylinClient.connect(KylinClient.java:285)
at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:70)
... 5 more
Goodbye!
38f9d37464b4%
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
Re:jdbc connection not working.
Posted by chuxiao <cr...@163.com>.
mark sure you can connection the "EMR cluster hostname":7070，
maybe network can not connection.
At 2020-07-13 11:58:34, "xatax" <ro...@gmail.com> wrote:
>I have attempted to connect to Kylin using jdbc driver for the following
>Kylin versions 2.6, 3.0.2 and 3.1 and have been unable to make connection.
>
>The driver files I have used are from the '$KYLIN_HOME/lib' directory:
>for version 3.1: kylin-jdbc-3.1.0.jar, jcl-over-slf4j-1.7.21.jar,
>slf4j-api-1.7.21.jar
>for version 2.6.6: kylin-jdbc-2.6.6.jar
>for version 3.0.2: kylin-jdbc-3.0.2.jar
>
>Connection URL I am using:
>jdbc:kylin://"EMR cluster hostname":7070/learn_kylin
>JDBC Driver class: org.apache.kylin.jdbc.Driver
>
>Will appreciate any insight into what might be going wrong.
>
>Error logs:
>
>38f9d37464b4% javac ky.java
>38f9d37464b4% java ky
>Connecting to database...
>SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>SLF4J: Defaulting to no-operation (NOP) logger implementation
>SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
>details.
>java.sql.SQLException:
>org.apache.kylin.jdbc.shaded.org.apache.http.conn.HttpHostConnectException:
>Connection to http://ec2-3-236-65-136.compute-1.amazonaws.com:7070 refused
> at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:72)
> at
>org.apache.kylin.jdbc.KylinJdbcFactory.newConnection(KylinJdbcFactory.java:77)
> at
>org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at ky.main(ky.java:22)
>Caused by:
>org.apache.kylin.jdbc.shaded.org.apache.http.conn.HttpHostConnectException:
>Connection to http://ec2-3-236-65-136.compute-1.amazonaws.com:7070 refused
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:190)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:294)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:643)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:479)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:906)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:805)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:784)
> at org.apache.kylin.jdbc.KylinClient.connect(KylinClient.java:285)
> at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:70)
> ... 5 more
>Caused by: java.net.ConnectException: Operation timed out (Connection timed
>out)
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at
>java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
> at
>java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
> at
>java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> at java.net.Socket.connect(Socket.java:606)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:127)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:180)
> ... 13 more
>Goodbye!
>38f9d37464b4% javac ky.java
>38f9d37464b4% java ky
>Connecting to database...
>SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>SLF4J: Defaulting to no-operation (NOP) logger implementation
>SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
>details.
>java.sql.SQLException: java.net.ConnectException: Operation timed out
>(Connection timed out)
> at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:72)
> at
>org.apache.kylin.jdbc.KylinJdbcFactory.newConnection(KylinJdbcFactory.java:77)
> at
>org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at ky.main(ky.java:22)
>Caused by: java.net.ConnectException: Operation timed out (Connection timed
>out)
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at
>java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
> at
>java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
> at
>java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> at java.net.Socket.connect(Socket.java:606)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:117)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:177)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:304)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:611)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:446)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:863)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57)
> at org.apache.kylin.jdbc.KylinClient.connect(KylinClient.java:285)
> at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:70)
> ... 5 more
>Goodbye!
>38f9d37464b4% java ky
>Connecting to database...
>SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>SLF4J: Defaulting to no-operation (NOP) logger implementation
>SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
>details.
>java.sql.SQLException: java.net.ConnectException: Operation timed out
>(Connection timed out)
> at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:72)
> at
>org.apache.kylin.jdbc.KylinJdbcFactory.newConnection(KylinJdbcFactory.java:77)
> at
>org.apache.kylin.jdbc.shaded.org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:247)
> at ky.main(ky.java:22)
>Caused by: java.net.ConnectException: Operation timed out (Connection timed
>out)
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at
>java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
> at
>java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
> at
>java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> at java.net.Socket.connect(Socket.java:606)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.conn.scheme.PlainSocketFactory.connectSocket(PlainSocketFactory.java:117)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:177)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.conn.ManagedClientConnectionImpl.open(ManagedClientConnectionImpl.java:304)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.tryConnect(DefaultRequestDirector.java:611)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:446)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.AbstractHttpClient.doExecute(AbstractHttpClient.java:863)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:82)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:106)
> at
>org.apache.kylin.jdbc.shaded.org.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:57)
> at org.apache.kylin.jdbc.KylinClient.connect(KylinClient.java:285)
> at org.apache.kylin.jdbc.KylinConnection.<init>(KylinConnection.java:70)
> ... 5 more
>Goodbye!
>38f9d37464b4%
>
>--
>Sent from: http://apache-kylin.74782.x6.nabble.com/