Unable to run USE catalog

[GiorgioBaldelli]

Hi Dan, thanks for sharing this! I'm currently trying to demo a similar set up and bumped into your repo.

I found some issues when trying to run the demo. Unfortunately, I haven't found a solution yet:

USE hive; and USE iceberg; both lead to the same error:

Query 20221123_100736_00002_j4s5s failed: line 1:1: Catalog must be specified when session catalog is not set
io.trino.spi.TrinoException: line 1:1: Catalog must be specified when session catalog is not set
        at io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:48)
        at io.trino.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:43)
        at io.trino.execution.UseTask.lambda$execute$1(UseTask.java:65)
        at java.base/java.util.Optional.orElseThrow(Optional.java:403)
        at io.trino.execution.UseTask.lambda$execute$2(UseTask.java:64)
        at java.base/java.util.Optional.orElseGet(Optional.java:364)
        at io.trino.execution.UseTask.execute(UseTask.java:64)
        at io.trino.execution.UseTask.execute(UseTask.java:36)
        at io.trino.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:145)
        at io.trino.execution.SqlQueryManager.createQuery(SqlQueryManager.java:249)
        at io.trino.dispatcher.LocalDispatchQuery.lambda$startExecution$7(LocalDispatchQuery.java:143)
        at io.trino.$gen.Trino_403____20221123_100619_2.run(Unknown Source)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
        at java.base/java.lang.Thread.run(Thread.java:833)

As a result of being unable to run the USE command, it seems impossible to isolate query execution to a specific database unfortunately.

---

The field location referenced in the example queries does not seem to exist. The correct field seems to be external_location.

(
    sepal_length DOUBLE,
    sepal_width  DOUBLE,
    petal_length DOUBLE,
    petal_width  DOUBLE,
    class        VARCHAR
)
WITH ( location = 's3a://iris/',
    format = 'PARQUET');

---

If you bumped into similar issues in the past, I'd be grateful for any hint you may have.

I'll report back in case I find a solution to the first problem.

Thank you in advance,
Giorgio