QuickStart
Running with Docker
- Requirements
- Install Docker
Quick start
-
Download the
duckdb-tpch-example
via the command linecurl https://codeload.github.com/canner/wren-engine/tar.gz/main |\tar -xz --strip=2 wren-engine-main/example/duckdb-tpch-example
duckdb-tpch-example
│
├── data
│ ├── customer.parquet
│ ├── lineitem.parquet
│ ├── nation.parquet
│ ├── orders.parquet
│ └── part.parquet
├── etc
│ ├── mdl
│ │ └── tpch.json
│ ├── accounts
│ ├── config.properties
│ ├── duckdb-init.sql
│ └── duckdb-session.sql
├── .env
├── docker-compose.yaml
└── README.mdOr use this link and paste this URL then press Enter
https://github.com/Canner/wren-engine/tree/main/example/duckdb-tpch-example
-
Modify
.env
on your platform. (linux/amd64
orlinux/arm64
)(M1, M2, M3 is arm64)PLATFORM=linux/amd64
ETC_PATH=./etc -
Run the
docker-compose
to start the engine servicedocker compose --env-file .env up
-
Connect from PostgreSQL drivers using port
7432
, example here we usepsql
psql 'host=localhost user=ina dbname=wren port=7432 options=--search_path=tpch'
If
psql: command not found
or not installpsql
, you can install it via this website -
Query the calculated fields
wren=> SELECT orderkey_linenumber FROM Lineitem;
orderkey_linenumber
---------------------
11
12
13
14
15
16
21
What’s Next?
- Check out the Advanced Tutorial which takes a much deeper dive into the key concepts and capabilities of Wren Engine