TPC H Status

This page lists the current status of TPC-H support in Peloton. For each of the 22 TPC-H queries, we list whether it works, and if not, what the cause of the issue is.

Query	Supported	Cause of error
Query #1	✔
Query #2	✔
Query #3	✔
Query #4	✕	Lacking support for SEMI joins.
Query #5	✔
Query #6	✔
Query #7	✕	Lacking support for subplans as expressions.
Query #8	✕
Query #9	✕
Query #10	✔
Query #11	✔
Query #12	✔
Query #13	✔
Query #14	✕	Null error.
Query #15	✕	Relies on materialized view.
Query #16	✔
Query #17	✕	Lacking support for subplans as expressions.
Query #18	✔
Query #19	✕	Unknown.
Query #20	✕	Lacking support for subplans as expressions.
Query #21	✕	Lacking support for ANTI join. Incorrect mapping from Postgres plan to Peloton plan.
Query #22	✕	Lacking support for ANTI join. Incorrect mapping from Postgres plan to Peloton plan.