Connection refused when connection to Dremio by dbeaver

1

Hello
I raised a Dremio container on docker desktop on my local machine by:
docker pull dremio/dremio-oss
docker run -p 9047:9047 -p 31010:31010 -p 32010:32010 -p 45678:45678 dremio/dremio-oss
Seems that container is up and running.
Trying to connect by dbeaver:
Added a new Dremio connection
host=localhost
port=31010
all are default values.
Then download jar file and try Test Connection but get an error:
Failure in connecting to Dremio: cdjd.com.dremio.exec.rpc.ConnectionFailedException: cdjd.com.dremio.exec.rpc.RpcException: CONNECTION : cdjd.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: no further information: localhost/127.0.0.1:31010
cdjd.com.dremio.exec.rpc.RpcException: CONNECTION : cdjd.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: no further information: localhost/127.0.0.1:31010
cdjd.com.dremio.exec.rpc.RpcException: CONNECTION : cdjd.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: no further information: localhost/127.0.0.1:31010
CONNECTION : cdjd.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: no further information: localhost/127.0.0.1:31010
CONNECTION : cdjd.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: no further information: localhost/127.0.0.1:31010
cdjd.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: no further information: localhost/127.0.0.1:31010
cdjd.io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: no further information: localhost/127.0.0.1:31010
Connection refused: no further information: localhost/127.0.0.1:31010
Connection refused: no further information: localhost/127.0.0.1:31010
Connection refused: no further information
Connection refused: no further information
Whould like to get help about it
Thanks

3

Seems that after connection to Dremio WEB UI and create a user - I managed to connect
but now I fail to create a table:
image

I tried:
CREATE TABLE testspace.customers (
id INTEGER,
firstname VARCHAR,
lastname VARCHAR
);

also with “”:
CREATE TABLE “testspace”.“customers” (
id INTEGER,
firstname VARCHAR,
lastname VARCHAR
);
but get:
SQL Error: UNSUPPORTED_OPERATION ERROR: Invalid path. Given path, [testspace.customers] is not valid.

[Error Id: 3e98f3dd-be16-4a1f-bd38-0bc9d0b2fba7 on 794538781d52:31010]

4

@R12345 CTAS can only happen into a file system source like S3 or HDFS or Azure or GCS and then a path.