diff options
| author |  Craig Tiller <ctiller@google.com> | 2017-06-06 15:26:26 -0700 |
|---|---|---|
| committer | Craig Tiller <ctiller@google.com> | 2017-06-06 15:26:26 -0700 |
| commit | c258713bb73d642e3bf1eb1dd8ccdb3f520323da (patch) | |
| tree | 6b3fd3d299c05f4e12e297119b4f8801c7306fc7 /tools/run_tests | |
| parent | 55d3ace0e805103ca776b0353055665802b520ed (diff) | |
Simplify query
Diffstat (limited to 'tools/run_tests')
| -rwxr-xr-x | tools/run_tests/run_tests.py | 9 |
1 files changed, 1 insertions, 8 deletions
diff --git a/tools/run_tests/run_tests.py b/tools/run_tests/run_tests.py index 7dbab0be00..77b81fb095 100755 --- a/tools/run_tests/run_tests.py +++ b/tools/run_tests/run_tests.py @@ -92,11 +92,6 @@ def get_flaky_tests(limit=None): test_name, SUM(result != 'PASSED' AND result != 'SKIPPED') AS count_failed, - SUM(result != 'SKIPPED') AS count_total, - 100 * SUM(result != 'PASSED' - AND result != 'SKIPPED') / SUM(result != 'SKIPPED') AS pct_failed, - MIN((TIMESTAMP_TO_SEC(CURRENT_TIMESTAMP()) - - TIMESTAMP_TO_SEC(timestamp))/60/60) AS age_in_hours FROM [grpc-testing:jenkins_test_results.aggregate_results] WHERE @@ -106,9 +101,7 @@ def get_flaky_tests(limit=None): GROUP BY test_name HAVING - pct_failed > 0 - ORDER BY - pct_failed DESC""" + count_failed > 0""" if limit: query += " limit {}".format(limit) query_job = bqu.sync_query_job(bq, 'grpc-testing', query) |