Quick Setup for Testing SQL Syntax on Different Dialects

Hive

export HIVE_VERSION=3.1.3
docker pull apache/hive:${HIVE_VERSION}
docker run -d -p 10000:10000 -p 10002:10002 --env SERVICE_NAME=hiveserver2 --name hive3 apache/hive:${HIVE_VERSION}
docker exec -it hive3 beeline -u jdbc:hive2://localhost:10000

MySQL

export MYSQL_VERSION=8.2.0
docker pull mysql:${MYSQL_VERSION}
docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:${MYSQL_VERSION}
docker exec -it some-mysql mysql -pmy-secret-pw

Postgres

export POSTGRES_VERSION=16.1
docker pull postgres:${POSTGRES_VERSION}
docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres:${POSTGRES_VERSION}
docker exec -it some-postgres psql -U postgres

SparkSQL

export SPARK_VERSION=3.5.0-scala2.12-java11-python3-ubuntu
docker pull spark:${SPARK_VERSION}
docker run -it spark:${SPARK_VERSION} /opt/spark/bin/spark-sql

Trino

export TRINO_VERSION=435
docker pull trinodb/trino:${TRINO_VERSION}
docker run -d -p 8080:8080 --name trino trinodb/trino:${TRINO_VERSION}
docker exec -it trino trino