README.md

presto-uuid

Plugin for https://prestodb.io/ that adds UUID support

How to setup a test presto-server using docker

First of all download presto-server-0.189.tar.gz and presto-cli-0.189-executable.jar from https://prestodb.io/.

chmod 755 presto-cli-0.189-executable.jar
tar -xzvf presto-server-0.189.tar.gz
mv presto-cli-0.189-executable.jar presto-server-0.189
mkdir -p presto-server-0.189/etc/catalog

Then create presto configurations,

presto-server-0.189/etc/catalog/pg4test.properties

connector.name=postgresql
connection-url=jdbc:postgresql://pg1:5432/test
connection-user=postgres
connection-password=postgres

presto-server-0.189/etc/config.properties

coordinator=true
node-scheduler.include-coordinator=true
http-server.http.port=8080
query.max-memory=10GB
query.max-memory-per-node=2GB
discovery-server.enabled=true
discovery.uri=http://localhost:8080

presto-server-0.189/etc/log.properties

com.facebook.presto=DEBUG

presto-server-0.189/etc/node.properties

node.environment=test
node.id=ffffffff-ffff-ffff-ffff-ffffffffffff
node.data-dir=/var/presto/data

presto-server-0.189/etc/jvm.config

-server
-Xmx4G
-XX:+UseG1GC
-XX:G1HeapRegionSize=32M
-XX:+UseGCOverheadLimit
-XX:+ExplicitGCInvokesConcurrent
-XX:+HeapDumpOnOutOfMemoryError
-XX:+ExitOnOutOfMemoryError

Finally, startup

postgresql

docker run --name pg -v `pwd`/postgresql:/var/lib/postgresql -e POSTGRES_PASSWORD=postgres -e PGDATA=/var/lib/postgresql/data/pgdata -d postgres:9.6.6
docker run -it --rm --link pg:pg1 postgres:9.6.6 psql -Upostgres -hpg1 -c "create database test"
docker run -it --rm --link pg:pg1 postgres:9.6.6 psql -Upostgres -hpg1 -dtest -c "create table books(id uuid PRIMARY KEY not null, title varchar(100), author varchar(100), publisher varchar(100), publish_time date)"

and presto-server

docker run -it --link pg:pg1 -v `pwd`/presto-server-0.189:/usr/local/bin/presto-server -v `pwd`/presto:/var/presto/data java:openjdk-8u111 
cd /usr/local/bin/presto-server/
bin/launcher start
./presto-cli-0.189-executable.jar --execute "show catalogs"
./presto-cli-0.189-executable.jar --catalog pg4test --execute "show schemas"
./presto-cli-0.189-executable.jar --catalog pg4test --schema public --execute "show tables"
./presto-cli-0.189-executable.jar --catalog pg4test --schema public --execute "show columns from books"
./presto-cli-0.189-executable.jar --execute "select uuid_type1()"