I’m trying to experiment with TileDB MariaDB MyTile engine, following instructions there: GitHub - TileDB-Inc/TileDB-MariaDB: MyTile is a MariaDB storage engine for accessing TileDB arrays.
docker run --rm -e MYSQL_ALLOW_EMPTY_PASSWORD=1 -e AWS_ACCESS_KEY_ID=somekey -e AWS_SECRET_ACCESS_KEY=somesecret -it tiledb/tiledb-mariadb
I have a tiledb array on s3, let’s say
s3://my-bucket/assay-1.tiledb. My understanding is there’s no cataloging needed, and I should be able to query that array with:
> select * from `s3://my-bucket/assay-1.tiledb`; ERROR 1146 (42S02): Table 'test.s3://my-bucket/assay-1.tiledb' doesn't exist
The credentials I passed are correct, as I can use them to open that array directly from python console, pointing to that same s3 url. Not sure how to skip the
test database, and it’s even needed.
Creating an array gives an error too:
> CREATE TABLE `s3://my-bucket/regions`( regionkey bigint WITH (dimension=true), name varchar, comment varchar ) uri = 's3://my-bucket/region' array_type='SPARSE'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WITH (dimension=true), name varchar, comment varchar ) uri = 's3://my-bucket...' at line 1
I checked the MyTile engine is indeed available with
SHOW ENGINES, it seems fine.
I’m not sure what I’m doing wrong there, I tried previous docker image versions, 0.10.0 and 0.9.5, same results. Any hints?