This environment will allow you to run Presto (Using docker-compose).
It Includes the following:
- MariaDB
- Hive 3.x
- Presto
Update the following configuration files with your AWS credentials:
etc/s3.propertieshive/conf/hdfs-site.xmlhive/conf/hive-site.xml
$ docker-compose up -d$ docker-compose exec -d hive hiveserver2 This will start Hive server in the background.
You could use beeline to connect to the server after it's up and running
$ docker-compose exec hive beeline -u jdbc:hive2://localhost:10000$ docker-compose exec presto presto-cli --catalog s3 --schema defaultUse the schema created throguh the Hive Server. (In this example the schema name is metrics)
docker-compose exec presto presto-cli --catalog s3 --schema schema_name Then query the table name we created in the schema.
SELECT * FROM table_name LIMIT 2;And you have a table full of data!