Can't turn off auto-committing; transactions are not supported. (Dremio is not transactional.)

1

I am trying to connect to dremio using JDBC driver client.

I used the following connection string:

jdbc:dremio:direct=hostname:31010

my query is

SELECT *
FROM “@admin”.“CME Quote-Vendor-File-Excel”;

But I am not able to connect.

I see some errors in my end as below:

java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717)
at cdjd.org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)
at cdjd.org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1141)

Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error)

But I do not see any errors in dremio.

I am running dremio on docker. I am using single node instance in this case.

Please advice

2

Hi @pavithrakc,

few things to try,

From your client (from where you are trying the jdbc request)

  1. ping
  2. telnet 31010

Can you also please send me the server.log from the Dremio coordinator?

Thanks,
@balaji.ramaswamy