beam icon indicating copy to clipboard operation
beam copied to clipboard

[TPC-DS] Store metrics into BigQuery and InfluxDB

Open aromanenko-dev opened this issue 2 years ago • 24 comments

Store TPC-DS metrics into BigQuery and InfluxDB:

  • Collect the results and send them into BigQuery and InfluxDB for every benchmark job;
  • Related Jenkins jobs are adjusted;
  • Removed Spark 2 runner support (Spark 2 is deprecated in Beam);
  • Added Grafana dashboards files;
  • Added more TPC-DS queries, that should pass with Beam SQL, to run on Jenkins.

Fixes #21254


Thank you for your contribution! Follow this checklist to help us incorporate your contribution quickly and easily:

  • [x] Choose reviewer(s) and mention them in a comment (R: @username).
  • [ ] Mention the appropriate issue in your description (for example: addresses #123), if applicable. This will automatically add a link to the pull request in the issue. If you would like the issue to automatically close on merging the pull request, comment fixes #<ISSUE NUMBER> instead.
  • [ ] Update CHANGES.md with noteworthy changes.
  • [ ] If this contribution is large, please file an Apache Individual Contributor License Agreement.

See the Contributor Guide for more tips on how to make review process smoother.

To check the build health, please visit https://github.com/apache/beam/blob/master/.test-infra/BUILD_STATUS.md

GitHub Actions Tests Status (on master branch)

Build python source distribution and wheels Python tests Java tests Go tests

See CI.md for more information about GitHub Actions CI.

aromanenko-dev avatar Aug 01 '22 17:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 03 '22 10:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 04 '22 08:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 04 '22 08:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 04 '22 08:08 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Aug 04 '22 09:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 04 '22 11:08 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Aug 04 '22 11:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 04 '22 12:08 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Aug 04 '22 14:08 aromanenko-dev

Run Flink Runner Tpcds Tests

aromanenko-dev avatar Aug 04 '22 14:08 aromanenko-dev

Run Dataflow Runner Tpcds Tests

aromanenko-dev avatar Aug 04 '22 14:08 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Aug 05 '22 14:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 05 '22 15:08 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Aug 05 '22 15:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 08 '22 15:08 aromanenko-dev

Run Flink Runner Tpcds Tests

aromanenko-dev avatar Aug 08 '22 15:08 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Aug 08 '22 15:08 aromanenko-dev

Run Dataflow Runner Tpcds Tests

aromanenko-dev avatar Aug 08 '22 15:08 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Aug 08 '22 16:08 aromanenko-dev

Run Dataflow Runner Tpcds Tests

aromanenko-dev avatar Aug 08 '22 16:08 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Aug 08 '22 16:08 aromanenko-dev

Run Flink Runner Tpcds Tests

aromanenko-dev avatar Aug 08 '22 16:08 aromanenko-dev

It's ready for review. R: @mosche R: @echauchot ptal

aromanenko-dev avatar Aug 09 '22 07:08 aromanenko-dev

Stopping reviewer notifications for this pull request: review requested by someone other than the bot, ceding control

github-actions[bot] avatar Aug 09 '22 08:08 github-actions[bot]

This PR is blocked on #22260 to address the rest of review comments regarding the new InfluxDB tool API.

aromanenko-dev avatar Aug 19 '22 13:08 aromanenko-dev

@mosche I updated PR with your recent InfluxDBPublisher changes. PTAL

aromanenko-dev avatar Sep 07 '22 15:09 aromanenko-dev

Run Seed Job

aromanenko-dev avatar Sep 09 '22 09:09 aromanenko-dev

Run Spark Runner Tpcds Tests

aromanenko-dev avatar Sep 09 '22 10:09 aromanenko-dev

Run Flink Runner Tpcds Tests

aromanenko-dev avatar Sep 09 '22 10:09 aromanenko-dev

Run Dataflow Runner Tpcds Tests

aromanenko-dev avatar Sep 09 '22 10:09 aromanenko-dev