TPC-H Benchmark
Note
Conformance is a work in progress. This page reflects the current implementation status to provide transparent insight into Opteryx’s capabilities and development progress.
Note
Performance in benchmarks should always be taken with some skepticism, benchmarks tend to be opinionated to specific characteristics and do not represent all factors which should be considered when comparing systems.
The Transaction Processing Performance Council (TPC) publishes industry-standard benchmarks for evaluating database and computer system performance. TPC-H is a decision support benchmark comprising a suite of complex, business-oriented queries. It simulates real-world analytical workloads that scan large volumes of data, perform intensive joins and aggregations, and answer critical business questions.
| Query | Modified | Pass | Issue |
|---|---|---|---|
| query1 | no | yes | - |
| query2 | yes | no | Multiway CROSS JOINs |
| query3 | no | no | Multiway CROSS JOINs |
| query4 | yes | yes | Support EXISTS |
| query5 | no | no | Multiway CROSS JOINs |
| query6 | no | yes | - |
| query7 | no | no | Multiway CROSS JOINs |
| query8 | no | no | Multiway CROSS JOINs |
| query9 | no | no | Multiway CROSS JOINs |
| query10 | no | no | Multiway CROSS JOINs |
| query11 | yes | no | Multiway CROSS JOINs |
| query12 | no | no | TPC-H 12 failure |
| query13 | yes | yes | Non-Equi JOINs |
| query14 | no | no | Temporal Clauses |
| query15 | yes | no | Multiway CROSS JOINs |
| query16 | no | no | Implied Aliases & IN Subquery |
| query17 | no | no | Reimplement CTEs |
| query18 | yes | no | Multiway CROSS JOINs |
| query19 | no | yes | - |
| query20 | no | no | IN Subquery |
| query21 | yes | no | Non-Equi JOINs |
| query22 | yes | no | Reimplement CTEs |
query doesn't complete within a reasonable time
All queries have been modified to refer to the location of the datasets, modified in the above table is where the SQL has been written to replace unsupported functionality with supported functionality - this is where the original query either created a view or a temporary table, both of these have been replaced with a CTE definition.
The test suite for this benchmark is in the Opteryx Benchmarking repository.
Legal Notice
TPC-H is Copyright © 1993-2022 Transaction Processing Performance Council.
The full TPC-H specification in PDF format can be found here.
TPC, TPC Benchmark, TPC-H are trademarks of the Transaction Processing Performance Council.