Add partsupplier to H2QueryRunner
@@ -81,6 +81,7 @@ import static io.airlift.tpch.TpchTable.LINE_ITEM;
import static io.airlift.tpch.TpchTable.NATION;
import static io.airlift.tpch.TpchTable.ORDERS;
import static io.airlift.tpch.TpchTable.PART;
+import static io.airlift.tpch.TpchTable.PART_SUPPLIER;
import static io.airlift.tpch.TpchTable.REGION;
import static java.lang.String.format;
import static java.util.Collections.nCopies;
@@ -130,6 +131,16 @@ public class H2QueryRunner
")");
insertRows(tpchMetadata, LINE_ITEM);
+ handle.execute(" CREATE TABLE partsupp (\n" +
+ " partkey BIGINT NOT NULL,\n" +
+ " suppkey BIGINT NOT NULL,\n" +
+ " availqty INTEGER NOT NULL,\n" +
+ " supplycost DOUBLE NOT NULL,\n" +
+ " comment VARCHAR(199) NOT NULL,\n" +
+ " PRIMARY KEY(partkey, suppkey)" +
+ ")");
+ insertRows(tpchMetadata, PART_SUPPLIER);
+
handle.execute("CREATE TABLE nation (\n" +
" nationkey BIGINT PRIMARY KEY,\n" +
" name VARCHAR(25) NOT NULL,\n" +
