Test load.sql (id 14ece930a354) (err)
load.stable.out.FILTERED 2019-01-10 05:53:45.291378066 +0100load.test.out.FILTERED 2019-01-10 05:53:45.294378092 +0100
1 Statistics about stdout of test 'load` in directory 'sql/benchmarks/tpcds`: 1 1 Statistics about stdout of test 'load` in directory 'sql/benchmarks/tpcds`: 1
2 27 lines, 84 words, 276 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 9 words, 71 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 27 lines, 84 words, 276 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 9 words, 71 chars in lines not matching '^$|^(\| |)#` 3
4 # 83 lines, 571 words, 5259 chars in all lines 4 ! 4 # 32 lines, 147 words, 1297 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
27 27 27 27
28 # 10:16:05 > 28 ! 28 # 05:53:45 > 28
29 # 10:16:05 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-18820" "--port=35163" 29 ! 29 # 05:53:45 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-9570" "--port=37532" 29
30 # 10:16:05 > 30 ! 30 # 05:53:45 > 30
31 31 31 31
32 #START TRANSACTION; 32 32 #START TRANSACTION; 32
33 #COPY 1 RECORDS INTO dbgen_version FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/dbgen_version.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 33 ! 33 33
34 [ 1 ] 34 ! 34 # 05:53:45 > 34
35 #COPY 20 RECORDS INTO income_band FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/income_band.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 35 ! 35 # 05:53:45 > "Done." 35
36 [ 20 ] 36 ! 36 # 05:53:45 > 36
37 #COPY 5 RECORDS INTO warehouse FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/warehouse.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 37 -
38 [ 5 ] 38 -
39 #COPY 20 RECORDS INTO ship_mode FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/ship_mode.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 39 -
40 [ 20 ] 40 -
41 #COPY 35 RECORDS INTO reason FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/reason.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 41 -
42 [ 35 ] 42 -
43 #COPY 6 RECORDS INTO call_center FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/call_center.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 43 -
44 [ 6 ] 44 -
45 #COPY 12 RECORDS INTO store FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/store.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 45 -
46 [ 12 ] 46 -
47 #COPY 60 RECORDS INTO web_page FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/web_page.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 47 -
48 [ 60 ] 48 -
49 #COPY 30 RECORDS INTO web_site FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/web_site.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 49 -
50 [ 30 ] 50 -
51 #COPY 300 RECORDS INTO promotion FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/promotion.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 51 -
52 [ 300 ] 52 -
53 #COPY 7200 RECORDS INTO household_demographics FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/household_demographics.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 53 -
54 [ 7200 ] 54 -
55 #COPY 11718 RECORDS INTO catalog_page FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/catalog_page.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 55 -
56 [ 11718 ] 56 -
57 #COPY 18000 RECORDS INTO item FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/item.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 57 -
58 [ 18000 ] 58 -
59 #COPY 86400 RECORDS INTO time_dim FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/time_dim.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 59 -
60 [ 86400 ] 60 -
61 #COPY 50000 RECORDS INTO customer_address FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/customer_address.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 61 -
62 [ 50000 ] 62 -
63 #COPY 71763 RECORDS INTO web_returns FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/web_returns.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 63 -
64 [ 71763 ] 64 -
65 #COPY 73049 RECORDS INTO date_dim FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/date_dim.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 65 -
66 [ 73049 ] 66 -
67 #COPY 100000 RECORDS INTO customer FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/customer.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 67 -
68 [ 100000 ] 68 -
69 #COPY 144067 RECORDS INTO catalog_returns FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/catalog_returns.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 69 -
70 [ 144067 ] 70 -
71 #COPY 287514 RECORDS INTO store_returns FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/store_returns.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 71 -
72 [ 287514 ] 72 -
73 #COPY 1920800 RECORDS INTO customer_demographics FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/customer_demographics.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 73 -
74 [ 1920800 ] 74 -
75 #COPY 719384 RECORDS INTO web_sales FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/web_sales.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 75 -
76 [ 719384 ] 76 -
77 #COPY 11745000 RECORDS INTO inventory FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/inventory.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 77 -
78 [ 11745000 ] 78 -
79 #COPY 1441548 RECORDS INTO catalog_sales FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/catalog_sales.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 79 -
80 [ 1441548 ] 80 -
81 #COPY 2880404 RECORDS INTO store_sales FROM '/home/ferreira/repositories/monetdb-test-data/tpcds/1/store_sales.dat' USING DELIMITERS '|', '|\n' NULL AS ''; 81 -
82 [ 2880404 ] 82 -
83 #COMMIT; 83 -
84 84 -
85 # 10:16:29 > 85 -
86 # 10:16:29 > "Done." 86 -
87 # 10:16:29 > 87 -
88 88 37 37