trino.yaml

package:
  name: trino
  version: "473"
  epoch: 0
  description: The distributed SQL query engine for big data, formerly known as PrestoSQL
  copyright:
    - license: Apache-2.0
  resources:
    cpu: 32
    memory: 64Gi
  dependencies:
    runtime:
      - openjdk-23-default-jvm
      - python3 # required by trino launcher script
      - trino-config

environment:
  contents:
    packages:
      - build-base
      - busybox
      - ca-certificates-bundle
      - curl
      - diffutils
      - git
      - go
      - jvmkill
      - maven
      - openjdk-23
      - upx
      - wolfi-base

pipeline:
  - uses: git-checkout
    working-directory: ./airlift/launcher
    with:
      repository: https://github.com/airlift/launcher.git
      tag: 301
      expected-commit: 2f521fa3de65a458c2d7879bc57841dd195b33df

  - working-directory: ./airlift/launcher
    runs: |
      export JAVA_HOME=/usr/lib/jvm/java-23-openjdk
      ./mvnw package

  - uses: git-checkout
    with:
      repository: https://github.com/trinodb/trino.git
      tag: ${{package.version}}
      expected-commit: 28e45d8e2405e57f2a57a42faf3d5f052d098226

  - uses: maven/pombump

  - runs: |
      set -x

      export JAVA_HOME=/usr/lib/jvm/java-23-openjdk

      ./mvnw package -q -DskipTests -Dmaven.source.skip=true -Dair.check.skip-all -T 8  -pl '!:trino-docs,!:trino-tests,!:trino-product-tests,!:trino-product-tests-launcher,!:trino-web-ui' -am

      mkdir -p ${{targets.destdir}}/usr/lib/trino
      cp ./core/trino-server/target/trino-server-${{package.version}}/NOTICE ${{targets.destdir}}/usr/lib/trino/
      cp ./core/trino-server/target/trino-server-${{package.version}}/README.txt ${{targets.destdir}}/usr/lib/trino/
      cp -r ./core/trino-server/target/trino-server-${{package.version}}/bin ${{targets.destdir}}/usr/lib/trino/bin/

      # copying rebuilt golang airlift/launcher ontop of current lancher
      cp -raf $HOME/airlift/launcher/target/binaries/** ${{targets.destdir}}/usr/lib/trino/bin/

      cp -r ./core/trino-server/target/trino-server-${{package.version}}/lib ${{targets.destdir}}/usr/lib/trino/lib/
      mkdir ${{targets.destdir}}/usr/lib/trino/plugin

      mkdir -p ${{targets.destdir}}/usr/bin/
      cp ./client/trino-cli/target/trino-cli-*-executable.jar ${{targets.destdir}}/usr/bin/trino
      chmod 0755 ${{targets.destdir}}/usr/bin/trino

data:
  - name: plugins
    items:
      bigquery: bigquery
      blackhole: blackhole
      cassandra: cassandra
      clickhouse: clickhouse
      delta-lake: delta-lake
      druid: druid
      elasticsearch: elasticsearch
      example-http: example-http
      exasol: exasol
      exchange-filesystem: exchange-filesystem
      exchange-hdfs: exchange-hdfs
      faker: faker
      geospatial: geospatial
      google-sheets: google-sheets
      hive: hive
      http-event-listener: http-event-listener
      http-server-event-listener: http-server-event-listener
      hudi: hudi
      iceberg: iceberg
      ignite: ignite
      jmx: jmx
      kafka: kafka
      kafka-event-listener: kafka-event-listener
      # kudu: kudu # kudu has an unfixable CVE (GHSA-735f-pc8j-v9w8), so we're not incuding it.
      mariadb: mariadb
      memory: memory
      ml: ml
      mongodb: mongodb
      mysql: mysql
      mysql-event-listener: mysql-event-listener
      opa: opa
      openlineage: openlineage
      opensearch: opensearch
      oracle: oracle
      password-authenticators: password-authenticators
      # phoenix5: phoenix5 # phoenix5 is riddled with CVEs, so we're not including it.
      pinot: pinot
      postgresql: postgresql
      prometheus: prometheus
      redis: redis
      redshift: redshift
      resource-group-managers: resource-group-managers
      session-property-managers: session-property-managers
      singlestore: singlestore
      snowflake: snowflake
      sqlserver: sqlserver
      teradata-functions: teradata-functions
      thrift: thrift
      tpcds: tpcds
      tpch: tpch
      vertica: vertica

subpackages:
  - name: ${{package.name}}-config
    description: Creates trino config step that can then be overridden.
    dependencies:
      runtime:
        - trino
    pipeline:
      - runs: |
          mkdir -p ${{targets.subpkgdir}}/etc
          cp -r core/docker/default/etc ${{targets.subpkgdir}}/etc/trino

  - name: ${{package.name}}-oci-entrypoint
    dependencies:
      runtime:
        - trino
        - bash # run-trino script needs bash
        - curl # health-check needs curl
    pipeline:
      - runs: |
          mkdir -p ${{targets.subpkgdir}}/usr/lib/trino/bin
          cp ./core/docker/bin/* ${{targets.subpkgdir}}/usr/lib/trino/bin/
          mkdir -p ${{targets.subpkgdir}}/usr/bin
          ln -s /usr/lib/trino/bin/run-trino ${{targets.subpkgdir}}/usr/bin/
          cp /usr/lib/libjvmkill.so ${{targets.subpkgdir}}/usr/lib/trino/bin/

          mkdir -p ${{targets.subpkgdir}}/etc/security/
          touch ${{targets.subpkgdir}}/etc/security/limits.conf
          cat << EOF >> ${{targets.subpkgdir}}/etc/security/limits.conf
          trino soft nofile 131072
          trino hard nofile 131072
          trino soft nproc 128000
          trino hard nproc 128000
          EOF
    test:
      pipeline:
        - uses: test/tw/ldd-check

  - range: plugins
    name: trino-plugin-${{range.key}}
    description: Trino Plugin ${{range.key}}
    dependencies:
      runtime:
        - trino
    pipeline:
      - runs: |
          mkdir -p ${{targets.subpkgdir}}/usr/lib/trino/lib
          cp -r ./core/trino-server/target/trino-server-${{package.version}}/plugin/${{range.value}}/* ${{targets.subpkgdir}}/usr/lib/trino/lib/

          mkdir -p ${{targets.subpkgdir}}/usr/lib/trino/plugin/${{range.value}}
          for path in ./core/trino-server/target/trino-server-${{package.version}}/plugin/${{range.value}}/*; do
            filename=$(basename $path)
            ln -s "../../lib/${filename}" "${{targets.subpkgdir}}/usr/lib/trino/plugin/${{range.value}}/${filename}"
          done

update:
  enabled: true
  github:
    identifier: trinodb/trino
    use-tag: true

test:
  environment:
    contents:
      packages:
        - ${{package.name}}-oci-entrypoint # need to setup basic
        - bash
    environment:
      JAVA_HOME: /usr/lib/jvm/java-23-openjdk
  pipeline:
    - name: "test trino version"
    - runs: |
        trino --version
        trino --help
    - uses: test/tw/ldd-check
    - name: "test trino server"
      runs: |
        mkdir -p /usr/lib/trino/etc

        export TRINO_ETC=/usr/lib/trino/etc
        # https://trino.io/docs/current/installation/deployment.html#node-properties
        cat << EOF >> "${TRINO_ETC}/node.properties"
        node.environment=production
        node.id=ffffffff-ffff-ffff-ffff-ffffffffffff
        node.data-dir=/var/trino/data
        EOF

        # https://trino.io/docs/current/installation/deployment.html#jvm-config
        cat << EOF >> "${TRINO_ETC}/jvm.config"
        -server
        -Xmx16G
        -XX:InitialRAMPercentage=80
        -XX:MaxRAMPercentage=80
        -XX:G1HeapRegionSize=32M
        -XX:+ExplicitGCInvokesConcurrent
        -XX:+ExitOnOutOfMemoryError
        -XX:+HeapDumpOnOutOfMemoryError
        -XX:-OmitStackTraceInFastThrow
        -XX:ReservedCodeCacheSize=512M
        -XX:PerMethodRecompilationCutoff=10000
        -XX:PerBytecodeRecompilationCutoff=10000
        -Djdk.attach.allowAttachSelf=true
        -Djdk.nio.maxCachedBufferSize=2000000
        -Dfile.encoding=UTF-8
        # Allow loading dynamic agent used by JOL
        -XX:+EnableDynamicAgentLoading
        EOF

        #https://trino.io/docs/current/installation/deployment.html#config-properties
        cat << EOF >> "${TRINO_ETC}/config.properties"
        coordinator=true
        node-scheduler.include-coordinator=true
        http-server.http.port=8080
        discovery.uri=http://example.net:8080
        EOF

        cat << EOF >> "${TRINO_ETC}/log.properties"
        io.trino=DEBUG
        EOF

        /usr/lib/trino/bin/launcher run & export PID=$! && sleep 10 && kill -9 $PID