Changeset: e352dc4b10d1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e352dc4b10d1 Modified Files: sql/benchmarks/tpch/load-sf-0.01-LOCKED.sql sql/benchmarks/tpch/load-sf-0.01.sql sql/benchmarks/tpch/load-sf-1.sql Branch: client-filetrans Log Message:
Test copy into from file ON CLIENT. diffs (64 lines): diff --git a/sql/benchmarks/tpch/load-sf-0.01-LOCKED.sql b/sql/benchmarks/tpch/load-sf-0.01-LOCKED.sql --- a/sql/benchmarks/tpch/load-sf-0.01-LOCKED.sql +++ b/sql/benchmarks/tpch/load-sf-0.01-LOCKED.sql @@ -1,8 +1,8 @@ -COPY 5 RECORDS INTO region from 'PWD/region.tbl' USING DELIMITERS '|', '|\n' LOCKED; -COPY 25 RECORDS INTO nation from 'PWD/nation.tbl' USING DELIMITERS '|', '|\n' LOCKED; -COPY 100 RECORDS INTO supplier from 'PWD/supplier.tbl' USING DELIMITERS '|', '|\n' LOCKED; -COPY 1500 RECORDS INTO customer from 'PWD/customer.tbl' USING DELIMITERS '|', '|\n' LOCKED; -COPY 2000 RECORDS INTO part from 'PWD/part.tbl' USING DELIMITERS '|', '|\n' LOCKED; -COPY 8000 RECORDS INTO partsupp from 'PWD/partsupp.tbl' USING DELIMITERS '|', '|\n' LOCKED; -COPY 15000 RECORDS INTO orders from 'PWD/orders.tbl' USING DELIMITERS '|', '|\n' LOCKED; -COPY 70000 RECORDS INTO lineitem from 'PWD/lineitem.tbl' USING DELIMITERS '|', '|\n' LOCKED; +COPY 5 RECORDS INTO region from 'PWD/region.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; +COPY 25 RECORDS INTO nation from 'PWD/nation.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; +COPY 100 RECORDS INTO supplier from 'PWD/supplier.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; +COPY 1500 RECORDS INTO customer from 'PWD/customer.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; +COPY 2000 RECORDS INTO part from 'PWD/part.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; +COPY 8000 RECORDS INTO partsupp from 'PWD/partsupp.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; +COPY 15000 RECORDS INTO orders from 'PWD/orders.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; +COPY 70000 RECORDS INTO lineitem from 'PWD/lineitem.tbl' ON CLIENT USING DELIMITERS '|', '|\n' LOCKED; diff --git a/sql/benchmarks/tpch/load-sf-0.01.sql b/sql/benchmarks/tpch/load-sf-0.01.sql --- a/sql/benchmarks/tpch/load-sf-0.01.sql +++ b/sql/benchmarks/tpch/load-sf-0.01.sql @@ -1,10 +1,10 @@ START TRANSACTION; -COPY 5 RECORDS INTO region from 'PWD/region.tbl' USING DELIMITERS '|', '|\n'; -COPY 25 RECORDS INTO nation from 'PWD/nation.tbl' USING DELIMITERS '|', '|\n'; -COPY 100 RECORDS INTO supplier from 'PWD/supplier.tbl' USING DELIMITERS '|', '|\n'; -COPY 1500 RECORDS INTO customer from 'PWD/customer.tbl' USING DELIMITERS '|', '|\n'; -COPY 2000 RECORDS INTO part from 'PWD/part.tbl' USING DELIMITERS '|', '|\n'; -COPY 8000 RECORDS INTO partsupp from 'PWD/partsupp.tbl' USING DELIMITERS '|', '|\n'; -COPY 15000 RECORDS INTO orders from 'PWD/orders.tbl' USING DELIMITERS '|', '|\n'; -COPY 70000 RECORDS INTO lineitem from 'PWD/lineitem.tbl' USING DELIMITERS '|', '|\n'; +COPY 5 RECORDS INTO region from 'PWD/region.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY 25 RECORDS INTO nation from 'PWD/nation.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY 100 RECORDS INTO supplier from 'PWD/supplier.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY 1500 RECORDS INTO customer from 'PWD/customer.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY 2000 RECORDS INTO part from 'PWD/part.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY 8000 RECORDS INTO partsupp from 'PWD/partsupp.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY 15000 RECORDS INTO orders from 'PWD/orders.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY 70000 RECORDS INTO lineitem from 'PWD/lineitem.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; COMMIT; diff --git a/sql/benchmarks/tpch/load-sf-1.sql b/sql/benchmarks/tpch/load-sf-1.sql --- a/sql/benchmarks/tpch/load-sf-1.sql +++ b/sql/benchmarks/tpch/load-sf-1.sql @@ -1,10 +1,10 @@ START TRANSACTION; -COPY INTO region from 'PWD/region.tbl' USING DELIMITERS '|', '|\n'; -COPY INTO nation from 'PWD/nation.tbl' USING DELIMITERS '|', '|\n'; -COPY INTO supplier from 'PWD/supplier.tbl' USING DELIMITERS '|', '|\n'; -COPY INTO customer from 'PWD/customer.tbl' USING DELIMITERS '|', '|\n'; -COPY INTO part from 'PWD/part.tbl' USING DELIMITERS '|', '|\n'; -COPY INTO partsupp from 'PWD/partsupp.tbl' USING DELIMITERS '|', '|\n'; -COPY INTO orders from 'PWD/orders.tbl' USING DELIMITERS '|', '|\n'; -COPY INTO lineitem from 'PWD/lineitem.tbl' USING DELIMITERS '|', '|\n'; +COPY INTO region from 'PWD/region.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY INTO nation from 'PWD/nation.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY INTO supplier from 'PWD/supplier.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY INTO customer from 'PWD/customer.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY INTO part from 'PWD/part.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY INTO partsupp from 'PWD/partsupp.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY INTO orders from 'PWD/orders.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; +COPY INTO lineitem from 'PWD/lineitem.tbl' ON CLIENT USING DELIMITERS '|', '|\n'; COMMIT; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list