Creating catalog/schema/table in prestosql/presto container

Question

I would like to use prestosql/presto container for automated tests. For this purpose I want to receive the ability to programmatically to create catalog/schema/table. Unfortunately, I didn't find the option via docker environment variables. If I trying to do it via jdbc connector, I receive following error:"This connector does not support creating tables"

How can I create schemas or tables using prestosql/presto container?

score 3 · Accepted Answer · answered Mar 24 '20 at 12:06

3

If you are writing tests in Java (as suggested by JDBC tag), you can use testcontainers library. It comes with Presto module.

uses prestosql/presto container under the hood
comes with Presto memory connector pre-installed, so you can create schemas & tables there

answered Mar 24 '20 at 12:06

Piotr Findeisen

19,480
2
52
82

Thanks! I tried the framework and it fits my requirements – barambuk Mar 25 '20 at 15:13
I encountered the same issue. Connecting to the "memory" catalog using the following JDBC string solved it for me: `jdbc:presto://localhost:8080/memory/default` – Tim Nieradzik Jan 26 '23 at 10:29

Creating catalog/schema/table in prestosql/presto container

1 Answers1