You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2022/02/14 08:41:00 UTC
[jira] [Updated] (IMPALA-11118) report_benchmark_results.py uses wrong compression codec in the per-query table
[ https://issues.apache.org/jira/browse/IMPALA-11118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Quanlong Huang updated IMPALA-11118:
------------------------------------
Fix Version/s: Impala 4.1.0
> 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
> Priority: Major
> Fix For: Impala 4.1.0
>
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org