15-799 Spring 2025 Project 1

Please see the project writeup for details.

Quickstart

1. Run ./setup.sh to download DuckDB and the workload.
2. Run ./optimize.sh ./workload.tgz output/ to compile and run the Calcite app.
3. Make your changes to ./calcite_app/src/main/java/edu/cmu/cs/db/calcite_app/app/App.java.

Useful Commands

Gradle

From the calcite_app/ folder,

# Build the app into a JAR: ./build/libs/calcite_app-1.0-SNAPSHOT.jar
./gradlew build
# Build the app into a JAR with all dependencies: ./build/libs/calcite_app-1.0-SNAPSHOT-all.jar
./gradlew shadowJar

Now, you can invoke your app:

java -jar build/libs/calcite_app-1.0-SNAPSHOT-all.jar "SELECT 1"

You may find it more convenient to chain it together during development:

./gradlew shadowJar && java -jar build/libs/calcite_app-1.0-SNAPSHOT-all.jar "SELECT 1"

If gradle starts acting up, you can clear its cache:

./gradlew --stop
rm -rf ~/.gradle/caches/ 

Submission

Run make submit to produce submission.zip. Upload the zip to Gradescope.