Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.0.0
-
None
-
MariaDB ColumnStore API to ColumnStore docker image
Description
Customer reported problem with Bulk load API not working in new and latest release.
They are getting: | Exception com.mariadb.columnstore.api.ColumnStoreException: Connection failure: ECONNREFUSED
There was discussion that in this Gamma release version that the APIs havent been fully tested, so this might be the issue. Or maybe they just don't have it fully configured correctly with the correct setup.
Customer info:
[root@f3d7dd436f06 /]# mariadb
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.5.4-MariaDB MariaDB Server
javamcsapi-1.2.2.jar
I'm trying to use the MariaDB ColumnStore API to do bulk inserts. I have the docker ColumnStore image running and the Java API running on a separate Ubuntu docker container. I've followed the documentation to modify the Columnstore.xml with the correct IP of the container. When attempting to create a bulk insert I get the following:
```
jshell> import com.mariadb.columnstore.api.*;
jshell> ColumnStoreDriver d = new ColumnStoreDriver("Columnstore_new.xml");
d ==> com.mariadb.columnstore.api.ColumnStoreDriver@5ce65a89
jshell> ColumnStoreBulkInsert bulkInsert = d.createBulkInsert("mcs", "idbtest", (short)0, 0);
Exception com.mariadb.columnstore.api.ColumnStoreException: Connection failure: ECONNREFUSED ``` |
I am able to to open a MariaDB console from Ubuntu the columnstore server just fine. I believe I need to set the credentials somewhere, I just don't know where.
https://github.com/mariadb-corporation/mariadb-columnstore-api
https://mariadb.com/kb/en/columnstore-bulk-write-sdk/#environment-configuration
https://hub.docker.com/r/mariadb/columnstore/