# Facing issue in creating an tiledb array or quering on any tiledb array on local minio S3 bucket using tiledb-presto **URL:** \ **Category:** Uncategorized\ **Created:** [August 19, 2020, 3:07pm UTC](https://forum.tiledb.com/t/facing-issue-in-creating-an-tiledb-array-or-quering-on-any-tiledb-array-on-local-minio-s3-bucket-using-tiledb-presto/242 "2020-08-19T15:07:20Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Shashikant255](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/shashikant255/32/94_2.png) [@Shashikant255](https://forum.tiledb.com/u/Shashikant255)\ **Post date:** [August 19, 2020, 3:07pm UTC](https://forum.tiledb.com/t/facing-issue-in-creating-an-tiledb-array-or-quering-on-any-tiledb-array-on-local-minio-s3-bucket-using-tiledb-presto/242/1 "2020-08-19T15:07:20Z")
I am trying to create a tiledb array on local minio S3 bucket using tiledb-presto docker. I have used below commad to start the docker:- `docker run -e AWS_ACCESS_KEY_ID= -e AWS_SECRET_ACCESS_KEY= -it --rm -v ./data/:/data/local_array tiledb/tiledb-presto` For creating an array I am using below command:- `CREATE TABLE region( regionkey bigint WITH (dimension=true), name varchar, comment varchar ) WITH (uri = 's3://:/testbucket/region');` This gives below error: > Query 20200819\_145407\_00007\_mp58g failed: [TileDB::S3] Error: Failed to create multipart request for object '/testbucket/region/\_\_array\_schema.tdb > Exception: > Error message: Unable to connect to endpoint In case I query for tiledb array on minio s3 bucket with below command:- `SELECT * FROM tiledb.tiledb."s3://:/testbucket/processed/csv_dowjones";` error msg:- > Query 20200819\_150351\_00008\_mp58g failed: line 1:15: Table tiledb.tiledb.s3://IP:Port/testbucket/processed/csv\_dowjones does not exist > SELECT \* FROM tiledb.tiledb.“s3://IP:Port/testbucket/processed/csv\_dowjones” Can anyone help to access local minio s3 bucket from tiledb-presto? @ihnorton ---
**Author:** ![Shashikant255](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/shashikant255/32/94_2.png) [@Shashikant255](https://forum.tiledb.com/u/Shashikant255)\ **Post date:** [August 24, 2020, 7:01am UTC](https://forum.tiledb.com/t/facing-issue-in-creating-an-tiledb-array-or-quering-on-any-tiledb-array-on-local-minio-s3-bucket-using-tiledb-presto/242/2 "2020-08-24T07:01:19Z")
There is no option to set endpoint url for minio. So currently not able to create any query on minio s3. This can be done by adding below code line in src/main/java/io/prestosql/plugin/tiledb/TileDBClient.java at 80 line ``` tileDBConfig.set("vfs.s3.scheme", "http"); tileDBConfig.set("vfs.s3.region", ""); tileDBConfig.set("vfs.s3.endpoint_override", "IP:Port"); tileDBConfig.set("vfs.s3.use_virtual_addressing", "false"); ``` ---
**Author:** ![seth](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@seth](https://forum.tiledb.com/u/seth)\ **Post date:** [August 24, 2020, 9:53pm UTC](https://forum.tiledb.com/t/facing-issue-in-creating-an-tiledb-array-or-quering-on-any-tiledb-array-on-local-minio-s3-bucket-using-tiledb-presto/242/3 "2020-08-24T21:53:20Z")
@Shashikant255 did adding the settings fix the problem? I’ve got two pull requests open for TileDB-Presto to update the TileDB-Java (and core TileDB) version, and second to add support for arbitrary configs. > > I plan to try to have them merged by tomorrow and cut a new release. We are in the process of also updating our Presto driver for the TileDB 2.0 features such as string dimensions, and heterogeneous dimensions. We expect to have the remaining features updated by mid September. Please let us know if you have any other problems, or feature requests and we will try to accommodate those as we are making changes. Lastly, a small question, what version of PrestoDB are you using? We are looking to also separately update our target version for the driver, so we are interested to know the version you are using. ---
**Author:** ![Shashikant255](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/shashikant255/32/94_2.png) [@Shashikant255](https://forum.tiledb.com/u/Shashikant255)\ **Post date:** [August 25, 2020, 9:19am UTC](https://forum.tiledb.com/t/facing-issue-in-creating-an-tiledb-array-or-quering-on-any-tiledb-array-on-local-minio-s3-bucket-using-tiledb-presto/242/4 "2020-08-25T09:19:25Z")
Thanks for your reply @seth . Yes, adding the setting fixed the problem. One more issue that I am facing is if I have created a tiledb array using tiledb function and I want to query on those array using tiledb-presto then it throws error like > Query 20200825\_073220\_00002\_g9pwj failed: line 1:15: Table tiledb.tiledb.s3://testbucket/processed/csv\_dowjones does not exist > select \* from tiledb.tiledb.“s3://testbucket/processed/csv\_dowjones” I am able to create, insert rows and query on table which is created by using tiledb-presto sql command. I don’t know what I am missing in this. We are currently in experimentation phase and have no prestodb version in production as of now. ---
**Author:** ![seth](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@seth](https://forum.tiledb.com/u/seth)\ **Post date:** [August 25, 2020, 9:17pm UTC](https://forum.tiledb.com/t/facing-issue-in-creating-an-tiledb-array-or-quering-on-any-tiledb-array-on-local-minio-s3-bucket-using-tiledb-presto/242/5 "2020-08-25T21:17:55Z")
@Shashikant255, we’ve released a new version of [TileDB-Presto, 1.6.0](https://github.com/TileDB-Inc/TileDB-Presto/releases/tag/1.6.0). I’d appreciate it if you would give that a try and see if it solves the s3 problem. The new `tiledb-config` session parameter details have been added to [our docs](https://docs.tiledb.com/prestodb/configuration-parameters). This should replace your need for altering the code. You can set the config parameters with ```auto set session tiledb.tiledb_config="vfs.s3.scheme=http,vfs.s3.endpoint_override=IP:Port,vfs.s3.use_virtual_addressing=false" ``` ---
**Author:** ![Shashikant255](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.tiledb.com/shashikant255/32/94_2.png) [@Shashikant255](https://forum.tiledb.com/u/Shashikant255)\ **Post date:** [August 26, 2020, 12:14pm UTC](https://forum.tiledb.com/t/facing-issue-in-creating-an-tiledb-array-or-quering-on-any-tiledb-array-on-local-minio-s3-bucket-using-tiledb-presto/242/6 "2020-08-26T12:14:31Z")
Yes, I am able to connect to minio. Thanks for your help.