[SQL] Support more features for window aggregates #8024
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # .github/workflows/ci.yml | |
| name: Build & Tests | |
| on: | |
| push: | |
| paths-ignore: | |
| - 'README.md' | |
| - 'CHANGELOG.md' | |
| - 'CODE_OF_CONDUCT.md' | |
| - 'CONTRIBUTING.md' | |
| - './vscode/**' | |
| pull_request: | |
| paths-ignore: | |
| - 'README.md' | |
| - 'CHANGELOG.md' | |
| - 'CODE_OF_CONDUCT.md' | |
| - 'CONTRIBUTING.md' | |
| - './vscode/**' | |
| env: | |
| CARGO_TERM_COLOR: always | |
| CARGO_NET_RETRY: 10 | |
| RUST_BACKTRACE: short | |
| RUSTUP_MAX_RETRIES: 10 | |
| REGISTRY: ghcr.io | |
| IMAGE_NAME: ${{ github.repository_owner }}/dbspmanager | |
| jobs: | |
| pre_job: | |
| runs-on: ubuntu-latest | |
| outputs: | |
| should_skip: ${{ steps.skip_check.outputs.should_skip }} | |
| steps: | |
| - id: skip_check | |
| uses: fkirc/skip-duplicate-actions@master | |
| with: | |
| concurrent_skipping: "same_content_newer" | |
| cancel_others: "true" | |
| skip_after_successful_duplicate: "true" | |
| do_not_skip: '["workflow_dispatch", "schedule"]' | |
| build: | |
| permissions: | |
| contents: read | |
| packages: write | |
| runs-on: [ self-hosted, skylake40 ] | |
| needs: [ pre_job ] | |
| if: ${{ needs.pre_job.outputs.should_skip != 'true' }} | |
| env: | |
| FORCE_COLOR: 1 | |
| steps: | |
| - uses: earthly/actions/setup-earthly@v1 | |
| with: | |
| version: v0.8.6 | |
| - uses: actions/checkout@v3 | |
| # By default a merge commit is checked out. If you look at the SHA that | |
| # is checked out, it doesn't match your local commit SHA. Rather it's | |
| # the SHA of a merge commit (your branch + base branch). So for | |
| # pull_request actions it won't match the commit ID on the branch. This | |
| # is confusing for storing benchmark results because the commit ID we | |
| # find during `git rev-parse` exists nowhere in the history. Since we | |
| # don't do merge commits anyways, we make sure we check out the head | |
| # commit (which will exist in the history). | |
| with: | |
| ref: ${{ github.event.pull_request.head.sha }} | |
| submodules: true | |
| - name: MUIX license | |
| run: echo "NEXT_PUBLIC_MUIX_PRO_KEY=${muix_license}" > web-console/.env && cat web-console/.env | |
| env: | |
| muix_license: ${{ secrets.muix_license }} | |
| - name: Integration test .env | |
| run: echo ${itest_config} > deploy/.env | |
| env: | |
| itest_config: ${{ secrets.itest_config }} | |
| # Ship secrets for the Snowflake CI account to Earthly. | |
| - name: Snowflake .env | |
| run: | | |
| echo SNOWFLAKE_CI_USER_PRIVATE_KEY_PASSPHRASE="${snowflake_passphrase}" >> deploy/.env && \ | |
| echo SNOWFLAKE_CI_USER_PRIVATE_KEY="${snowflake_key}" >> deploy/.env && \ | |
| echo SNOWFLAKE_CI_USER_PASSWORD="${snowflake_password}" >> deploy/.env | |
| env: | |
| snowflake_key: ${{ secrets.snowflake_ci_user_private_key }} | |
| snowflake_passphrase: ${{ secrets.snowflake_ci_user_private_key_passphrase }} | |
| snowflake_password: ${{ secrets.snowflake_ci_user_password }} | |
| # Ship secrets for the S3 CI account for the S3 input transport test to Earthly. | |
| - name: S3 .env | |
| run: | | |
| echo CI_S3_AWS_ACCESS_KEY="${s3_access_key}" >> deploy/.env && \ | |
| echo CI_S3_AWS_SECRET="${s3_secret}" >> deploy/.env | |
| env: | |
| s3_access_key: ${{ secrets.ci_s3_aws_access_key }} | |
| s3_secret: ${{ secrets.ci_s3_aws_secret }} | |
| # Ship secrets for the AWS CI account for the delta table output transport test to Earthly. | |
| - name: Delta output S3 secrets | |
| run: | | |
| echo DELTA_TABLE_TEST_AWS_ACCESS_KEY_ID="${delta_table_test_aws_access_key_id}" >> .arg && \ | |
| echo DELTA_TABLE_TEST_AWS_SECRET_ACCESS_KEY="${delta_table_test_aws_secret_access_key}" >> .arg | |
| env: | |
| delta_table_test_aws_access_key_id: ${{ secrets.delta_table_test_aws_access_key_id }} | |
| delta_table_test_aws_secret_access_key: ${{ secrets.delta_table_test_aws_secret_access_key }} | |
| - name: Print ulimit | |
| run: ulimit -a | |
| - name: Earthly version | |
| run: earthly --version | |
| - name: Run CI | |
| # run: earthly -P --ci --env-file-path .ci.env +all-tests | |
| run: earthly -P --ci +all-tests | |
| - uses: actions/upload-artifact@v3 | |
| if: always() | |
| with: | |
| name: playwright-artifacts | |
| path: playwright-artifacts/ | |
| retention-days: 10 | |
| - name: Remove test artifacts from the CI machine | |
| run: rm -f playwright-artifacts/* |