# Error connecting to dremio via JDBC driver from Spark scala

**URL:** <https://community.dremio.com/t/error-connecting-to-dremio-via-jdbc-driver-from-spark-scala/1915>\
**Category:** Uncategorized\
**Created:** [September 24, 2018, 4:34am UTC](https://community.dremio.com/t/error-connecting-to-dremio-via-jdbc-driver-from-spark-scala/1915 "2018-09-24T04:34:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sajeev\_ramakrishnan](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@sajeev\_ramakrishnan](https://community.dremio.com/u/sajeev_ramakrishnan)\
**Post date:** [September 24, 2018, 4:34am UTC](https://community.dremio.com/t/error-connecting-to-dremio-via-jdbc-driver-from-spark-scala/1915/1 "2018-09-24T04:34:22Z")

</div>

Dear Team,  
I am facing one error while trying to create a table in dremio using JDBC driver, invoked via Spark.

I am trying to create a table. The query is visible for almost 3 minutes in the jobs link. But later reports that it was cancelled. Below is the error that I am seeing in the Spark job.

2018-09-24 05:27:28 INFO QueryResultHandler:763 - User Error Occurred [ErrorId: 6dcd6a47-4efb-4dce-8f54-60c98f9d2b2d]  
cdjd.com.dremio.common.exceptions.UserException: Connection null \<–\> null (user client) closed unexpectedly. SabotNode down?  
at cdjd.com.dremio.common.exceptions.UserException$Builder.build(UserException.java:746)  
at cdjd.com.dremio.sabot.rpc.user.QueryResultHandler$ChannelClosedHandler$1.operationComplete(QueryResultHandler.java:372)  
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:511)  
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:504)  
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:483)  
at cdjd.io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:424)  
at cdjd.io.netty.util.concurrent.DefaultPromise.trySuccess(DefaultPromise.java:103)  
at cdjd.io.netty.channel.DefaultChannelPromise.trySuccess(DefaultChannelPromise.java:84)  
at cdjd.io.netty.channel.AbstractChannel$CloseFuture.setClosed(AbstractChannel.java:1148)  
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.doClose0(AbstractChannel.java:764)  
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:740)  
at cdjd.io.netty.channel.AbstractChannel$AbstractUnsafe.close(AbstractChannel.java:611)  
at cdjd.io.netty.channel.DefaultChannelPipeline$HeadContext.close(DefaultChannelPipeline.java:1356)  
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:624)  
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:608)  
at cdjd.io.netty.channel.ChannelOutboundHandlerAdapter.close(ChannelOutboundHandlerAdapter.java:71)  
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:624)  
at cdjd.io.netty.channel.AbstractChannelHandlerContext.close(AbstractChannelHandlerContext.java:608)  
at cdjd.io.netty.channel.ChannelDuplexHandler.close(ChannelDuplexHandler.java:73)  
at cdjd.io.netty.channel.AbstractChannelHandlerContext.invokeClose(AbstractChannelHandlerContext.java:624)  
at cdjd.io.netty.channel.AbstractChannelHandlerContext.access$1100(AbstractChannelHandlerContext.java:38)  
at cdjd.io.netty.channel.AbstractChannelHandlerContext$13.run(AbstractChannelHandlerContext.java:613)  
at cdjd.io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:163)  
at cdjd.io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:404)  
at cdjd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:463)  
at cdjd.io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:886)  
at java.lang.Thread.run(Thread.java:745)  
2018-09-24 05:27:28 INFO DremioCursor$ResultsListener:171 - [#2] Query failed:  
cdjd.com.dremio.common.exceptions.UserException: Connection null \<–\> null (user client) closed unexpectedly. SabotNode down?  
at cdjd.com.dremio.common.exceptions.UserException$Builder.build(UserException.java:746)  
at cdjd.com.dremio.sabot.rpc.user.QueryResultHandler$ChannelClosedHandler$1.operationComplete(QueryResultHandler.java:372)

But when I try to execute this using spark-shell via dremio JDBC, there is no issue.

Can you please throw some light on this?

Regards,  
Sajeev

---

<div class="post-metadata">

**Author:** ![raju](https://avatars.discourse-cdn.com/v4/letter/r/a183cd/32.png) [@raju](https://community.dremio.com/u/raju)\
**Post date:** [October 4, 2019, 6:57pm UTC](https://community.dremio.com/t/error-connecting-to-dremio-via-jdbc-driver-from-spark-scala/1915/2 "2019-10-04T18:57:24Z")

</div>

Any luck with this ? I am getting same error and I can’t figure it out

---

<div class="post-metadata">

**Author:** ![david.lee](https://avatars.discourse-cdn.com/v4/letter/d/ed655f/32.png) [@david.lee](https://community.dremio.com/u/david.lee)\
**Post date:** [October 4, 2019, 7:23pm UTC](https://community.dremio.com/t/error-connecting-to-dremio-via-jdbc-driver-from-spark-scala/1915/3 "2019-10-04T19:23:29Z")

</div>

Not sure how you are creating a table. The create table syntax was only recently added.

[https://docs.dremio.com/sql-reference/sql-commands/tables.html#creating-tables](https://docs.dremio.com/sql-reference/sql-commands/tables.html#creating-tables)

I’m assuming you’ve added the Dremio JDBC jar to the Spark’s jar list

.

---

<div class="post-metadata">

**Author:** ![kprifogle](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kprifogle/32/1719_2.png) [@kprifogle](https://community.dremio.com/u/kprifogle)\
**Post date:** [December 9, 2019, 5:48am UTC](https://community.dremio.com/t/error-connecting-to-dremio-via-jdbc-driver-from-spark-scala/1915/4 "2019-12-09T05:48:39Z")

</div>

Having same issue[bad\_more.zip](https://community.dremio.com/uploads/short-url/kUKswj7ttECRu0L2GmIdojOnMFI.zip) (34.8 KB)