docker-compose up
./trino-cli-388-executable.jar --server http://localhost:8080
USE hive;
CREATE SCHEMA IF NOT EXISTS iris
WITH (location = 's3a://iris/');
CREATE TABLE IF NOT EXISTS hive.iris.iris_parquet
(
sepal_length DOUBLE,
sepal_width DOUBLE,
petal_length DOUBLE,
petal_width DOUBLE,
class VARCHAR
)
WITH ( location = 's3a://iris/',
format = 'PARQUET');
USE iceberg;
CREATE SCHEMA IF NOT EXISTS iris
WITH (location = 's3a://iris/');
CREATE TABLE IF NOT EXISTS iceberg.iris.iris_parquet
(
sepal_length DOUBLE,
sepal_width DOUBLE,
petal_length DOUBLE,
petal_width DOUBLE,
class VARCHAR
)
WITH (format = 'PARQUET');
insert into iceberg.iris.iris_empty_parquet (select * from hive.iris.iris_parquet);