You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2022/02/12 07:01:00 UTC
[jira] [Created] (IMPALA-11118) report_benchmark_results.py uses wrong compression codec in the per-query table
Quanlong Huang created IMPALA-11118:
---------------------------------------
Summary: report_benchmark_results.py uses wrong compression codec in the per-query table
Key: IMPALA-11118
URL: https://issues.apache.org/jira/browse/IMPALA-11118
Project: IMPALA
Issue Type: Bug
Components: Infrastructure
Reporter: Quanlong Huang
Assignee: Quanlong Huang
When running single_node_perf_run.sh, I got results like this
{code:java}
+------------+--------------------+---------+------------+------------+----------------+
| Workload | File Format | Avg (s) | Delta(Avg) | GeoMean(s) | Delta(GeoMean) |
+------------+--------------------+---------+------------+------------+----------------+
| TPCDS(100) | orc / snap / block | 25.41 | -14.62% | 8.42 | -15.27% |
+------------+--------------------+---------+------------+------------+----------------+
+------------+-------------+---------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+------+
| Workload | Query | File Format | Avg(s) | Base Avg(s) | Delta(Avg) | StdDev(%) | Base StdDev(%) | Iters | Median Diff(%) | MW Zval | Tval |
+------------+-------------+---------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+------+
| TPCDS(100) | TPCDS-Q59 | orc / block / block | 18.99 | 15.57 | +21.94% | 0.00% | 0.00% | 2 | +17.99% | 1.00 | 0 |
| TPCDS(100) | TPCDS-Q90 | orc / block / block | 3.26 | 2.75 | +18.70% | 0.00% | 0.00% | 2 | +15.75% | 1.00 | 0 |
| TPCDS(100) | TPCDS-Q1 | orc / block / block | 5.46 | 4.66 | +17.30% | 0.00% | 0.00% | 2 | +14.75% | 1.00 | 0 |
......
| TPCDS(100) | TPCDS-Q80A | orc / block / block | 24.71 | 76.83 | -67.83% | 0.00% | 0.00% | 2 | -210.88% | -1.00 | 0 |
| TPCDS(100) | TPCDS-Q39-2 | orc / block / block | 4.83 | 17.31 | -72.09% | 0.00% | 0.00% | 2 | -258.26% | -1.00 | 0 |
| TPCDS(100) | TPCDS-Q39-1 | orc / block / block | 4.92 | 17.93 | -72.59% | 0.00% | 0.00% | 2 | -264.85% | -1.00 | 0 |
+------------+-------------+---------------------+--------+-------------+------------+-----------+----------------+-------+----------------+---------+------+
{code}
The file format in the per-query table should be "orc/snap/block" instead of "orc/block/block".
--
This message was sent by Atlassian Jira
(v8.20.1#820001)