History

kev c6b6795224 update		2020-08-19 15:27:40 +08:00
..
conf	update presto	2019-10-23 10:09:42 +08:00
Dockerfile.alpine	update	2020-08-19 15:27:40 +08:00
Dockerfile.debian	update	2020-08-19 15:27:40 +08:00
README.md	update prestodb	2020-08-17 14:49:50 +08:00
docker-compose.yml	split presto to prestodb+prestosql	2019-10-21 11:36:26 +08:00
docker-stack.yml	update prestodb	2020-08-17 14:49:50 +08:00

README.md

prestodb

Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.

standalone mode

prestodb:
  image: vimagick/prestodb
  ports:
    - "8080:8080"
  volumes:
    - ./conf/standalone:/opt/presto/etc:ro
    - /data:/data
  restart: unless-stopped

cluster mode

$ ansible all -a 'mkdir -p /data'

$ docker stack deploy -c docker-stack.yml prestodb

$ docker ps | grep prestodb_coordinator | awk '{print $1}'
4cc5c6c420d7

$ docker exec -it 4cc5c6c420d7 presto --server localhost:8080 --catalog tpch
>>> show schemas;
>>> show tables from tiny;
>>> select * from tiny.customer limit 10;
>>> quit

$ curl http://localhost:8080/ui/

$ curl http://localhost:8080/v1/service/presto/general

⚠️ If volume settings are changed, you need to remove them manually on all nodes.