Changeset: 0d6a22537b43 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0d6a22537b43 Added Files: sql/benchmarks/tpcds/Tests/load.sql.in Removed Files: sql/benchmarks/tpcds/Tests/load.py.in Modified Files: sql/benchmarks/tpcds/Tests/check1.stable.out sql/benchmarks/tpcds/Tests/load.stable.out Branch: default Log Message:
Changed tpcds workload to sf1. diffs (truncated from 674 to 300 lines): diff --git a/sql/benchmarks/tpcds/Tests/check1.stable.out b/sql/benchmarks/tpcds/Tests/check1.stable.out --- a/sql/benchmarks/tpcds/Tests/check1.stable.out +++ b/sql/benchmarks/tpcds/Tests/check1.stable.out @@ -35,8 +35,8 @@ Ready. % sys.L3 # table_name % L3 # name % bigint # type -% 4 # length -[ 1000 ] +% 5 # length +[ 50000 ] #select count(*) from customer_demographics; % sys.L3 # table_name % L3 # name @@ -54,7 +54,7 @@ Ready. % L3 # name % bigint # type % 1 # length -[ 1 ] +[ 5 ] #select count(*) from ship_mode; % sys.L3 # table_name % L3 # name @@ -71,8 +71,8 @@ Ready. % sys.L3 # table_name % L3 # name % bigint # type -% 1 # length -[ 1 ] +% 2 # length +[ 35 ] #select count(*) from income_band; % sys.L3 # table_name % L3 # name @@ -83,38 +83,38 @@ Ready. % sys.L3 # table_name % L3 # name % bigint # type -% 4 # length -[ 2000 ] +% 5 # length +[ 18000 ] #select count(*) from store; % sys.L3 # table_name % L3 # name % bigint # type -% 1 # length -[ 2 ] +% 2 # length +[ 12 ] #select count(*) from call_center; % sys.L3 # table_name % L3 # name % bigint # type % 1 # length -[ 2 ] +[ 6 ] #select count(*) from customer; % sys.L3 # table_name % L3 # name % bigint # type -% 4 # length -[ 1000 ] +% 6 # length +[ 100000 ] #select count(*) from web_site; % sys.L3 # table_name % L3 # name % bigint # type -% 1 # length -[ 2 ] +% 2 # length +[ 30 ] #select count(*) from store_returns; % sys.L3 # table_name % L3 # name % bigint # type -% 5 # length -[ 11925 ] +% 6 # length +[ 287514 ] #select count(*) from household_demographics; % sys.L3 # table_name % L3 # name @@ -125,14 +125,14 @@ Ready. % sys.L3 # table_name % L3 # name % bigint # type -% 1 # length -[ 2 ] +% 2 # length +[ 60 ] #select count(*) from promotion; % sys.L3 # table_name % L3 # name % bigint # type -% 1 # length -[ 3 ] +% 3 # length +[ 300 ] #select count(*) from catalog_page; % sys.L3 # table_name % L3 # name @@ -143,44 +143,44 @@ Ready. % sys.L3 # table_name % L3 # name % bigint # type -% 6 # length -[ 261261 ] +% 8 # length +[ 11745000 ] #select count(*) from catalog_returns; % sys.L3 # table_name % L3 # name % bigint # type -% 4 # length -[ 8923 ] +% 6 # length +[ 144067 ] #select count(*) from web_returns; % sys.L3 # table_name % L3 # name % bigint # type -% 4 # length -[ 1152 ] -#select count(*) from web_sales; -% sys.L3 # table_name -% L3 # name -% bigint # type % 5 # length -[ 11876 ] +[ 71763 ] +#select count(*) from web_sales; +% sys.L3 # table_name +% L3 # name +% bigint # type +% 6 # length +[ 719384 ] #select count(*) from catalog_sales; % sys.L3 # table_name % L3 # name % bigint # type -% 5 # length -[ 89807 ] +% 7 # length +[ 1441548 ] #select count(*) from store_sales; % sys.L3 # table_name % L3 # name % bigint # type -% 6 # length -[ 120527 ] +% 7 # length +[ 2880404 ] #select * from dbgen_version limit 9; % sys.dbgen_version, sys.dbgen_version, sys.dbgen_version, sys.dbgen_version # table_name % dv_version, dv_create_date, dv_create_time, dv_cmdline_args # name % varchar, date, time, varchar # type -% 5, 10, 8, 12 # length -[ "2.0.0", 2018-11-01, 14:42:56, "--scale 0.01" ] +% 5, 10, 8, 0 # length +[ "2.0.0", 2018-11-02, 17:31:46, NULL ] #select * from customer_address limit 9; % sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address, sys.customer_address # table_name % ca_address_sk, ca_address_id, ca_street_number, ca_street_name, ca_street_type, ca_suite_number, ca_city, ca_county, ca_state, ca_zip, ca_country, ca_gmt_offset, ca_location_type # name @@ -227,8 +227,12 @@ Ready. % sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse, sys.warehouse # table_name % w_warehouse_sk, w_warehouse_id, w_warehouse_name, w_warehouse_sq_ft, w_street_number, w_street_name, w_street_type, w_suite_number, w_city, w_county, w_state, w_zip, w_country, w_gmt_offset # name % int, char, varchar, int, char, varchar, char, char, varchar, varchar, char, char, varchar, decimal # type -% 1, 16, 19, 6, 10, 4, 15, 10, 6, 17, 2, 10, 13, 7 # length -[ 1, "AAAAAAAABAAAAAAA", "Conventional childr", 977787, "651", "6th ", "Parkway", "Suite 470", "Midway", "Williamson County", "TN", "31904", "United States", -5.00 ] +% 1, 16, 20, 6, 10, 10, 15, 10, 8, 17, 2, 10, 13, 7 # length +[ 1, "AAAAAAAABAAAAAAA", "Conventional childr", 977787, "651", "6th ", "Parkway", "Suite 470", "Fairview", "Williamson County", "TN", "35709", "United States", -5.00 ] +[ 2, "AAAAAAAACAAAAAAA", "Important issues liv", 138504, "600", "View First", "Avenue", "Suite P", "Fairview", "Williamson County", "TN", "35709", "United States", -5.00 ] +[ 3, "AAAAAAAADAAAAAAA", "Doors canno", 294242, "534", "Ash Laurel", "Dr.", "Suite 0", "Fairview", "Williamson County", "TN", "35709", "United States", -5.00 ] +[ 4, "AAAAAAAAEAAAAAAA", "Bad cards must make.", 621234, "368", "Wilson Elm", "Drive", "Suite 80", "Fairview", "Williamson County", "TN", "35709", "United States", -5.00 ] +[ 5, "AAAAAAAAFAAAAAAA", NULL, NULL, NULL, NULL, NULL, NULL, "Fairview", "Williamson County", "TN", "35709", "United States", NULL ] #select * from ship_mode limit 9; % sys.ship_mode, sys.ship_mode, sys.ship_mode, sys.ship_mode, sys.ship_mode, sys.ship_mode # table_name % sm_ship_mode_sk, sm_ship_mode_id, sm_type, sm_code, sm_carrier, sm_contract # name @@ -263,6 +267,14 @@ Ready. % int, char, char # type % 1, 16, 100 # length [ 1, "AAAAAAAABAAAAAAA", "Package was damaged" ] +[ 2, "AAAAAAAACAAAAAAA", "Stopped working" ] +[ 3, "AAAAAAAADAAAAAAA", "Did not get it on time" ] +[ 4, "AAAAAAAAEAAAAAAA", "Not the product that was ordred" ] +[ 5, "AAAAAAAAFAAAAAAA", "Parts missing" ] +[ 6, "AAAAAAAAGAAAAAAA", "Does not work with a product that I have" ] +[ 7, "AAAAAAAAHAAAAAAA", "Gift exchange" ] +[ 8, "AAAAAAAAIAAAAAAA", "Did not like the color" ] +[ 9, "AAAAAAAAJAAAAAAA", "Did not like the model" ] #select * from income_band limit 9; % sys.income_band, sys.income_band, sys.income_band # table_name % ib_income_band_sk, ib_lower_bound, ib_upper_bound # name @@ -295,51 +307,69 @@ Ready. % sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store, sys.store # table_name % s_store_sk, s_store_id, s_rec_start_date, s_rec_end_date, s_closed_date_sk, s_store_name, s_number_employees, s_floor_space, s_hours, s_manager, s_market_id, s_geography_class, s_market_desc, s_market_manager, s_division_id, s_division_name, s_company_id, s_company_name, s_street_number, s_street_name, s_street_type, s_suite_number, s_city, s_county, s_state, s_zip, s_country, s_gmt_offset, s_tax_precentage # name % int, char, date, date, int, varchar, int, int, char, varchar, int, varchar, varchar, varchar, int, varchar, int, varchar, varchar, varchar, char, char, varchar, varchar, char, char, varchar, decimal, decimal # type -% 1, 16, 10, 10, 7, 5, 3, 7, 20, 12, 1, 7, 56, 16, 1, 7, 1, 7, 3, 9, 15, 10, 6, 17, 2, 10, 13, 7, 7 # length +% 1, 16, 10, 10, 7, 5, 3, 7, 20, 12, 2, 7, 94, 16, 1, 7, 1, 7, 3, 11, 15, 10, 8, 17, 2, 10, 13, 7, 7 # length [ 1, "AAAAAAAABAAAAAAA", 1997-03-13, NULL, 2451189, "ought", 245, 5250760, "8AM-4PM", "William Ward", 2, "Unknown", "Enough high areas stop expectations. Elaborate, local is", "Charles Bartley", 1, "Unknown", 1, "Unknown", "767", "Spring ", "Wy", "Suite 250", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.03 ] [ 2, "AAAAAAAACAAAAAAA", 1997-03-13, 2000-03-12, NULL, "able", 236, 5285950, "8AM-4PM", "Scott Smith", 8, "Unknown", "Parliamentary candidates wait then heavy, keen mil", "David Lamontagne", 1, "Unknown", 1, "Unknown", "255", "Sycamore ", "Dr.", "Suite 410", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.03 ] +[ 3, "AAAAAAAACAAAAAAA", 2000-03-13, NULL, NULL, "able", 236, 7557959, "8AM-4PM", "Scott Smith", 7, "Unknown", "Impossible, true arms can treat constant, complete w", "David Lamontagne", 1, "Unknown", 1, "Unknown", "877", "Park Laurel", "Road", "Suite T", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.03 ] +[ 4, "AAAAAAAAEAAAAAAA", 1997-03-13, 1999-03-13, 2451044, "ese", 218, 9341467, "8AM-4PM", "Edwin Adams", 4, "Unknown", "Events would achieve other, eastern hours. Mechanisms must not eat other, new org", "Thomas Pollack", 1, "Unknown", 1, "Unknown", "27", "Lake ", "Ln", "Suite 260", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.03 ] +[ 5, "AAAAAAAAEAAAAAAA", 1999-03-14, 2001-03-12, 2450910, "anti", 288, 9078805, "8AM-4PM", "Edwin Adams", 8, "Unknown", "Events would achieve other, eastern hours. Mechanisms must not eat other, new org", "Thomas Pollack", 1, "Unknown", 1, "Unknown", "27", "Lee 6th", "Court", "Suite 80", "Fairview", "Williamson County", "TN", "35709", "United States", -5.00, 0.03 ] +[ 6, "AAAAAAAAEAAAAAAA", 2001-03-13, NULL, NULL, "cally", 229, 9026222, "8AM-4PM", "Edwin Adams", 10, "Unknown", "Events would achieve other, eastern hours. Mechanisms must not eat other, new org", "Thomas Pollack", 1, "Unknown", 1, "Unknown", "220", "6th ", "Lane", "Suite 140", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.03 ] +[ 7, "AAAAAAAAHAAAAAAA", 1997-03-13, NULL, NULL, "ation", 297, 8954883, "8AM-4PM", "David Thomas", 9, "Unknown", "Architects coul", "Thomas Benton", 1, "Unknown", 1, "Unknown", "811", "Lee ", "Circle", "Suite T", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.01 ] +[ 8, "AAAAAAAAIAAAAAAA", 1997-03-13, 2000-03-12, NULL, "eing", 278, 6995995, "8AM-4PM", "Brett Yates", 2, "Unknown", "Various bars make most. Difficult levels introduce at a boots. Buildings welcome only never el", "Dean Morrison", 1, "Unknown", 1, "Unknown", "226", "12th ", "Lane", "Suite D", "Fairview", "Williamson County", "TN", "35709", "United States", -5.00, 0.08 ] +[ 9, "AAAAAAAAIAAAAAAA", 2000-03-13, NULL, NULL, "eing", 271, 6995995, "8AM-4PM", "Brett Yates", 2, "Unknown", "Formal, psychological pounds relate reasonable, young principles. Black, ", "Dean Morrison", 1, "Unknown", 1, "Unknown", "226", "Hill ", "Boulevard", "Suite 190", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.08 ] #select * from call_center limit 9; % sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center, sys.call_center # table_name % cc_call_center_sk, cc_call_center_id, cc_rec_start_date, cc_rec_end_date, cc_closed_date_sk, cc_open_date_sk, cc_name, cc_class, cc_employees, cc_sq_ft, cc_hours, cc_manager, cc_mkt_id, cc_mkt_class, cc_mkt_desc, cc_market_manager, cc_division, cc_division_name, cc_company, cc_company_name, cc_street_number, cc_street_name, cc_street_type, cc_suite_number, cc_city, cc_county, cc_state, cc_zip, cc_country, cc_gmt_offset, cc_tax_percentage # name % int, char, date, date, int, int, varchar, varchar, int, int, char, varchar, int, char, varchar, varchar, int, varchar, int, char, char, varchar, char, char, varchar, varchar, char, char, varchar, decimal, decimal # type -% 1, 16, 10, 10, 1, 7, 12, 6, 1, 4, 20, 14, 1, 50, 64, 13, 1, 4, 1, 50, 10, 11, 15, 10, 6, 17, 2, 10, 13, 7, 7 # length +% 1, 16, 10, 10, 1, 7, 13, 6, 1, 4, 20, 14, 1, 50, 92, 15, 1, 5, 1, 50, 10, 11, 15, 10, 6, 17, 2, 10, 13, 7, 7 # length [ 1, "AAAAAAAABAAAAAAA", 1998-01-01, NULL, NULL, 2450952, "NY Metro", "large", 2, 1138, "8AM-4PM", "Bob Belcher", 6, "More than other authori", "Shared others could not count fully dollars. New members ca", "Julius Tran", 3, "pri", 6, "cally", "730", "Ash Hill", "Boulevard", "Suite 0", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.11 ] [ 2, "AAAAAAAACAAAAAAA", 1998-01-01, 2000-12-31, NULL, 2450806, "Mid Atlantic", "medium", 6, 2268, "8AM-8AM", "Felipe Perkins", 2, "A bit narrow forms matter animals. Consist", "Largely blank years put substantially deaf, new others. Question", "Julius Durham", 5, "anti", 1, "ought", "984", "Center Hill", "Way", "Suite 70", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.12 ] +[ 3, "AAAAAAAACAAAAAAA", 2001-01-01, NULL, NULL, 2450806, "Mid Atlantic", "medium", 6, 4134, "8AM-4PM", "Mark Hightower", 2, "Wrong troops shall work sometimes in a opti", "Largely blank years put substantially deaf, new others. Question", "Julius Durham", 1, "ought", 2, "able", "984", "Center Hill", "Way", "Suite 70", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.01 ] +[ 4, "AAAAAAAAEAAAAAAA", 1998-01-01, 2000-01-01, NULL, 2451063, "North Midwest", "medium", 1, 649, "8AM-4PM", "Larry Mccray", 2, "Dealers make most historical, direct students", "Rich groups catch longer other fears; future,", "Matthew Clifton", 4, "ese", 3, "pri", "463", "Pine Ridge", "RD", "Suite U", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.05 ] +[ 5, "AAAAAAAAEAAAAAAA", 2000-01-02, 2001-12-31, NULL, 2451063, "North Midwest", "small", 3, 795, "8AM-8AM", "Larry Mccray", 2, "Dealers make most historical, direct students", "Blue, due beds come. Politicians would not make far thoughts. Specifically new horses partic", "Gary Colburn", 4, "ese", 3, "pri", "463", "Pine Ridge", "RD", "Suite U", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.12 ] +[ 6, "AAAAAAAAEAAAAAAA", 2002-01-01, NULL, NULL, 2451063, "North Midwest", "medium", 7, 3514, "8AM-4PM", "Larry Mccray", 5, "Silly particles could pro", "Blue, due beds come. Politicians would not make far thoughts. Specifically new horses partic", "Gary Colburn", 5, "anti", 3, "pri", "463", "Pine Ridge", "RD", "Suite U", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.11 ] #select * from customer limit 9; % sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer # table_name % c_customer_sk, c_customer_id, c_current_cdemo_sk, c_current_hdemo_sk, c_current_addr_sk, c_first_shipto_date_sk, c_first_sales_date_sk, c_salutation, c_first_name, c_last_name, c_preferred_cust_flag, c_birth_day, c_birth_month, c_birth_year, c_birth_country, c_login, c_email_address, c_last_review_date_sk # name % int, char, int, int, int, int, int, char, char, char, char, int, int, int, varchar, char, char, int # type -% 1, 16, 7, 4, 3, 7, 7, 10, 20, 30, 1, 2, 2, 4, 18, 13, 50, 7 # length -[ 1, "AAAAAAAABAAAAAAA", 980124, 7135, 946, 2452238, 2452208, "Mr.", "Javier", "Lewis", "Y", 9, 12, 1936, "CHILE", NULL, "[email protected]", 2452508 ] -[ 2, "AAAAAAAACAAAAAAA", 819667, 1461, 655, 2452318, 2452288, "Dr.", "Amy", "Moses", "Y", 9, 4, 1966, "TOGO", NULL, "[email protected]", 2452318 ] -[ 3, "AAAAAAAADAAAAAAA", 1473522, 6247, 572, 2449130, 2449100, "Miss", "Latisha", "Hamilton", "N", 18, 9, 1979, "NIUE", NULL, "[email protected]", 2452313 ] -[ 4, "AAAAAAAAEAAAAAAA", 1703214, 3986, 558, 2450030, 2450000, "Dr.", "Michael", "White", "N", 7, 6, 1983, "MEXICO", NULL, "[email protected]", 2452361 ] -[ 5, "AAAAAAAAFAAAAAAA", 953372, 4470, 368, 2449438, 2449408, "Sir", "Robert", "Moran", "N", 8, 5, 1956, "FIJI", NULL, "[email protected]", 2452469 ] -[ 6, "AAAAAAAAGAAAAAAA", 213219, 6374, 82, 2451883, 2451853, "Ms.", "Brunilda", "Sharp", "N", 4, 12, 1925, "SURINAME", NULL, "[email protected]", 2452430 ] -[ 7, "AAAAAAAAHAAAAAAA", 68377, 3219, 814, 2451438, 2451408, "Ms.", "Fonda", "Wiles", "Y", 24, 4, 1985, "GAMBIA", NULL, "[email protected]", 2452360 ] -[ 8, "AAAAAAAAIAAAAAAA", 1215897, 2471, 598, 2449406, 2449376, "Sir", "Ollie", "Shipman", "N", 26, 12, 1938, "KOREA, REPUBLIC OF", NULL, "[email protected]", 2452334 ] -[ 9, "AAAAAAAAJAAAAAAA", 1168667, 1404, 388, 2452275, 2452245, "Sir", "Karl", "Gilbert", "N", 26, 10, 1966, "MONTSERRAT", NULL, "[email protected]", 2452454 ] +% 1, 16, 7, 4, 5, 7, 7, 10, 20, 30, 1, 2, 2, 4, 18, 13, 50, 7 # length +[ 1, "AAAAAAAABAAAAAAA", 980124, 7135, 32946, 2452238, 2452208, "Mr.", "Javier", "Lewis", "Y", 9, 12, 1936, "CHILE", NULL, "[email protected]", 2452508 ] +[ 2, "AAAAAAAACAAAAAAA", 819667, 1461, 31655, 2452318, 2452288, "Dr.", "Amy", "Moses", "Y", 9, 4, 1966, "TOGO", NULL, "[email protected]", 2452318 ] +[ 3, "AAAAAAAADAAAAAAA", 1473522, 6247, 48572, 2449130, 2449100, "Miss", "Latisha", "Hamilton", "N", 18, 9, 1979, "NIUE", NULL, "[email protected]", 2452313 ] +[ 4, "AAAAAAAAEAAAAAAA", 1703214, 3986, 39558, 2450030, 2450000, "Dr.", "Michael", "White", "N", 7, 6, 1983, "MEXICO", NULL, "[email protected]", 2452361 ] +[ 5, "AAAAAAAAFAAAAAAA", 953372, 4470, 36368, 2449438, 2449408, "Sir", "Robert", "Moran", "N", 8, 5, 1956, "FIJI", NULL, "[email protected]", 2452469 ] +[ 6, "AAAAAAAAGAAAAAAA", 213219, 6374, 27082, 2451883, 2451853, "Ms.", "Brunilda", "Sharp", "N", 4, 12, 1925, "SURINAME", NULL, "[email protected]", 2452430 ] +[ 7, "AAAAAAAAHAAAAAAA", 68377, 3219, 44814, 2451438, 2451408, "Ms.", "Fonda", "Wiles", "Y", 24, 4, 1985, "GAMBIA", NULL, "[email protected]", 2452360 ] +[ 8, "AAAAAAAAIAAAAAAA", 1215897, 2471, 16598, 2449406, 2449376, "Sir", "Ollie", "Shipman", "N", 26, 12, 1938, "KOREA, REPUBLIC OF", NULL, "[email protected]", 2452334 ] +[ 9, "AAAAAAAAJAAAAAAA", 1168667, 1404, 49388, 2452275, 2452245, "Sir", "Karl", "Gilbert", "N", 26, 10, 1966, "MONTSERRAT", NULL, "[email protected]", 2452454 ] #select * from web_site limit 9; % sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site, sys.web_site # table_name % web_site_sk, web_site_id, web_rec_start_date, web_rec_end_date, web_name, web_open_date_sk, web_close_date_sk, web_class, web_manager, web_mkt_id, web_mkt_class, web_mkt_desc, web_market_manager, web_company_id, web_company_name, web_street_number, web_street_name, web_street_type, web_suite_number, web_city, web_county, web_state, web_zip, web_country, web_gmt_offset, web_tax_percentage # name % int, char, date, date, varchar, int, int, varchar, varchar, int, varchar, varchar, varchar, int, char, char, varchar, char, char, varchar, varchar, char, char, varchar, decimal, decimal # type -% 1, 16, 10, 10, 6, 7, 7, 7, 14, 1, 46, 75, 11, 1, 50, 10, 14, 15, 10, 6, 17, 2, 10, 13, 7, 7 # length +% 1, 16, 10, 10, 6, 7, 7, 7, 15, 1, 46, 92, 13, 1, 50, 10, 14, 15, 10, 8, 17, 2, 10, 13, 7, 7 # length [ 1, "AAAAAAAABAAAAAAA", 1997-08-16, NULL, "site_0", 2450807, NULL, "Unknown", "Ronald Shaffer", 4, "Grey lines ought to result indeed centres. Tod", "Well similar decisions used to keep hardly democratic, personal priorities.", "Joe George", 6, "cally", "51", "Dogwood Sunset", "Ln", "Suite 330", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.10 ] -[ 2, "AAAAAAAACAAAAAAA", 1997-08-16, 2000-08-15, "site_0", 2450798, 2448973, "Unknown", "Tommy Jones", 6, "Completely excellent things ought to pro", "Lucky passengers know. Red details will not hang alive, international s", "David Myers", 4, "ese", "358", "Ridge Wilson", "Cir.", "Suite 150", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.00 ] +[ 2, "AAAAAAAACAAAAAAA", 1997-08-16, 2000-08-15, "site_0", 2450798, 2447148, "Unknown", "Tommy Jones", 6, "Completely excellent things ought to pro", "Lucky passengers know. Red details will not hang alive, international s", "David Myers", 4, "ese", "358", "Ridge Wilson", "Cir.", "Suite 150", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.00 ] +[ 3, "AAAAAAAACAAAAAAA", 2000-08-16, NULL, "site_0", 2450798, 2447148, "Unknown", "Tommy Jones", 3, "Completely excellent things ought to pro", "Particular, common seasons shall not indicate fully more single decisions; ", "David Myers", 4, "ese", "753", "7th ", "Pkwy", "Suite 210", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.02 ] +[ 4, "AAAAAAAAEAAAAAAA", 1997-08-16, 1999-08-16, "site_0", 2450781, 2448956, "Unknown", "Harold Wilson", 5, "As strong notes deal questions. Proud visito", "Deeply small books cannot extend all similar, clear historians. Free, new camp", "James Harris", 5, "anti", "805", "Hill Hill", "Dr.", "Suite R", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.08 ] +[ 5, "AAAAAAAAEAAAAAAA", 1999-08-17, 2001-08-15, "site_0", 2450781, 2448956, "Unknown", "Harold Wilson", 5, "Wide, final representat", "Deeply small books cannot extend all similar, clear historians. Free, new camp", "Edward George", 1, "ought", "805", "2nd 3rd", "Road", "Suite R", "Fairview", "Williamson County", "TN", "31904", "United States", -5.00, 0.08 ] +[ 6, "AAAAAAAAEAAAAAAA", 2001-08-16, NULL, "site_0", 2450781, 2448956, "Unknown", "Harold Wilson", 5, "Wide, final representat", "Thin roles should run quickly. Patient parts include even in the ladies; only united trouser", "John Sheppard", 3, "ought", "63", "Hickory 3rd", "Ct.", "Suite 130", "Fairview", "Williamson County", "TN", "31904", "United States", -5.00, 0.08 ] +[ 7, "AAAAAAAAHAAAAAAA", 1997-08-16, NULL, "site_1", 2450756, NULL, "Unknown", "Moses Hicks", 4, "New homes comment great. Possibilities re", "Enough small animals emerge at a holidays. Managers expect only.", "William Reyes", 4, "ese", "784", "Central ", "Dr.", "Suite Q", "Fairview", "Williamson County", "TN", "35709", "United States", -5.00, 0.12 ] +[ 8, "AAAAAAAAIAAAAAAA", 1997-08-16, 2000-08-15, "site_1", 2450747, 2448922, "Unknown", "Charles Parker", 1, "Only, temporary services ", "Physical witnesses might not agree really already existing prayers. Loyal, possible m", "Gerald Craft", 5, "anti", "835", "Washington ", "Avenue", "Suite 470", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.07 ] +[ 9, "AAAAAAAAIAAAAAAA", 2000-08-16, NULL, "site_1", 2450747, 2448922, "Unknown", "Marshall Conner", 6, "Labour cars withdraw big, full issues", "Physical witnesses might not agree really already existing prayers. Loyal, possible m", "Scott Bryant", 1, "anti", "835", "11th ", "Cir.", "Suite R", "Midway", "Williamson County", "TN", "31904", "United States", -5.00, 0.07 ] #select * from store_returns limit 9; % sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns, sys.store_returns # table_name % sr_returned_date_sk, sr_return_time_sk, sr_item_sk, sr_customer_sk, sr_cdemo_sk, sr_hdemo_sk, sr_addr_sk, sr_store_sk, sr_reason_sk, sr_ticket_number, sr_return_quantity, sr_return_amt, sr_return_tax, sr_return_amt_inc_tax, sr_fee, sr_return_ship_cost, sr_refunded_cash, sr_reversed_charge, sr_store_credit, sr_net_loss # name % int, int, int, int, int, int, int, int, int, int, int, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal, decimal # type -% 7, 5, 4, 3, 7, 4, 3, 1, 1, 1, 2, 9, 9, 9, 9, 9, 9, 9, 9, 9 # length -[ 2451984, 46418, 404, 6, 793022, 4033, 397, 2, 1, 1, 51, 37.23, 3.35, 40.58, 55.28, 714.00, 0.74, 17.51, 18.98, 772.63 ] -[ 2451822, 47480, 1813, 6, 1082163, 7157, 751, 1, 1, 1, 43, 4009.32, 120.27, 4129.59, 28.23, 0.00, 3448.01, 5.61, 555.70, 148.50 ] -[ 2451653, 37700, 1030, 284, 289468, 3067, 819, 2, 1, 2, 7, 249.48, 2.49, 251.97, 11.50, 6.23, 234.51, 8.83, 6.14, 20.22 ] -[ 2452682, 38957, 1719, 47, 793786, 6401, 663, 2, 1, 3, 3, 227.37, 6.82, 234.19, 9.23, 33.42, 125.05, 51.16, 51.16, 49.47 ] -[ 2452682, 41617, 1063, 47, 193750, 2351, 152, 1, 1, 3, 23, 1273.05, 25.46, 1298.51, 46.15, 406.18, 954.78, 57.28, 260.99, 477.79 ] -[ 2452688, 60645, 1545, 47, 1047081, 2455, 76, 2, 1, 3, 1, 35.14, 2.45, 37.59, 79.00, 0.00, 9.13, 5.20, 20.81, 81.45 ] -[ 2451598, 40772, 397, 814, 722383, 1497, 164, 2, 1, 4, 18, 63.54, 1.27, 64.81, 1.26, 10.80, 33.67, 2.68, 27.19, 13.33 ] -[ 2451521, 33881, 908, 814, 925501, 3196, 491, 2, 1, 4, 12, 18.60, 1.48, 20.08, 46.48, 270.60, 10.04, 8.04, 0.52, 318.56 ] -[ 2451628, 34073, 1790, 246, 1150235, 3185, 935, 1, 1, 5, 58, 347.42, 6.94, 354.36, 97.98, 331.18, 107.70, 14.38, 225.34, 436.10 ] +% 7, 5, 5, 5, 7, 4, 5, 2, 2, 1, 2, 9, 9, 9, 9, 9, 9, 9, 9, 9 # length +[ 2451984, 46418, 4553, 67006, 793022, 4033, 17397, 7, 19, 1, 51, 37.23, 3.35, 40.58, 55.28, 714.00, 0.74, 17.51, 18.98, 772.63 ] +[ 2451822, 47480, 10993, 67006, 1082163, 7157, 49751, 1, 29, 1, 43, 4009.32, 120.27, 4129.59, 28.23, 0.00, 3448.01, 5.61, 555.70, 148.50 ] +[ 2451653, 37700, 7654, 68284, 289468, 3067, 21819, 10, 35, 2, 7, 249.48, 2.49, 251.97, 11.50, 6.23, 234.51, 8.83, 6.14, 20.22 ] +[ 2452682, 38957, 17263, 44047, 793786, 6401, 10663, 2, 15, 3, 3, 227.37, 6.82, 234.19, 9.23, 33.42, 125.05, 51.16, 51.16, 49.47 ] +[ 2452682, 41617, 10693, 44047, 193750, 2351, 8152, 8, 9, 3, 23, 1273.05, 25.46, 1298.51, 46.15, 406.18, 954.78, 57.28, 260.99, 477.79 ] +[ 2452688, 60645, 16869, 44047, 1047081, 2455, 45076, 2, 1, 3, 1, 35.14, 2.45, 37.59, 79.00, 0.00, 9.13, 5.20, 20.81, 81.45 ] +[ 2451598, 40772, 5515, 38814, 722383, 1497, 44164, 2, 35, 4, 18, 63.54, 1.27, 64.81, 1.26, 10.80, 33.67, 2.68, 27.19, 13.33 ] +[ 2451521, 33881, 6988, 38814, 925501, 3196, 34491, 2, 21, 4, 12, 18.60, 1.48, 20.08, 46.48, 270.60, 10.04, 8.04, 0.52, 318.56 ] +[ 2451628, 34073, 12650, 13246, 1150235, 3185, 36935, 8, 27, 5, 58, 347.42, 6.94, 354.36, 97.98, 331.18, 107.70, 14.38, 225.34, 436.10 ] #select * from household_demographics limit 9; % sys.household_demographics, sys.household_demographics, sys.household_demographics, sys.household_demographics, sys.household_demographics # table_name % hd_demo_sk, hd_income_band_sk, hd_buy_potential, hd_dep_count, hd_vehicle_count # name @@ -358,17 +388,30 @@ Ready. % sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page, sys.web_page # table_name % wp_web_page_sk, wp_web_page_id, wp_rec_start_date, wp_rec_end_date, wp_creation_date_sk, wp_access_date_sk, wp_autogen_flag, wp_customer_sk, wp_url, wp_type, wp_char_count, wp_link_count, wp_image_count, wp_max_ad_count # name % int, char, date, date, int, int, char, int, varchar, char, int, int, int, int # type -% 1, 16, 10, 10, 7, 7, 1, 3, 18, 50, 4, 1, 1, 1 # length -[ 1, "AAAAAAAABAAAAAAA", 1997-09-03, NULL, 2450810, 2452620, "Y", 539, "http://www.foo.com";, "welcome", 2531, 8, 3, 4 ] +% 1, 16, 10, 10, 7, 7, 1, 5, 18, 50, 4, 2, 1, 1 # length +[ 1, "AAAAAAAABAAAAAAA", 1997-09-03, NULL, 2450810, 2452620, "Y", 98539, "http://www.foo.com";, "welcome", 2531, 8, 3, 4 ] [ 2, "AAAAAAAACAAAAAAA", 1997-09-03, 2000-09-02, 2450814, 2452580, "N", NULL, "http://www.foo.com";, "protected", 1564, 4, 3, 1 ] +[ 3, "AAAAAAAACAAAAAAA", 2000-09-03, NULL, 2450814, 2452611, "N", NULL, "http://www.foo.com";, "feedback", 1564, 4, 3, 4 ] +[ 4, "AAAAAAAAEAAAAAAA", 1997-09-03, 1999-09-03, 2450812, 2452579, "N", NULL, "http://www.foo.com";, "general", 3732, 18, 7, 1 ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
