TPC-H Benchmark
Note
Conformance is a work in progress and this information represents the current state in order to provide transparent information about progress and capability.
TPC publish a set of benchmarks for computer and database systems. TPC-H is a decision support benchmark which consists of a set of business-oriented queries. This benchmark demonstrates a decision support system that examines large amounts of data, executes highly complex queries, and answers key business questions.
Query | Modified | Pass | Issue |
---|---|---|---|
query1 | no | yes | - |
query2 | yes | no | Multiway CROSS JOINs |
query3 | no | no | Multiway CROSS JOINs |
query4 | no | no | 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 | no | no | 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.
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.