1. 获取镜像
# 查看可用的稳定版本
sudo docker search presto
# 镜像大小:1GB
sudo docker pull prestosql/presto:321
sudo docker image ls |grep presto
2. 启动容器
sudo docker run -d --name=presto -p 28080:8080 prestosql/presto:321
sudo docker ps |grep presto
sudo docker start presto
sudo docker restart presto
sudo docker stop presto
sudo docker rm presto
3. 验证
sudo docker exec -it presto bash
Web UI:http://LTSR003:28080
4. 集成
Presto集成MySQL
# 进入容器
docker exec -it presto bash
# 添加连接器配置文件
vi /usr/lib/presto/etc/catalog/mysql.properties
内容如下:
connector.name=mysql
connection-url=jdbc:mysql://172.16.0.6:3306?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false
connection-user=root
connection-password=root
重启容器:
sudo docker restart presto
验证:
docker exec -it presto bash
# presto CLI
presto --server localhost:8099 --catalog=mysql --schema=huedb
show tables;
Presto集成Elasticsearch
# 进入容器
docker exec -it presto bash
# 添加连接器配置文件
vi /usr/lib/presto/etc/catalog/elasticsearch.properties
内容如下:
connector.name=elasticsearch
elasticsearch.host=10.8.0.125
elasticsearch.port=9200
重启容器:
sudo docker restart presto
验证:
docker exec -it presto bash
# presto CLI
presto
show tables from elasticsearch.default;