数据仓库服务 GAUSSDB(DWS)-TPC-DS测试数据

时间：2024-10-22 11:41:47

TPC-DS测试数据

表1 TPC-DS测试数据
序号	表名	行数	表大小
1	customer_address	6,000,000	126MB
2	customer_demographics	1,920,800	11MB
3	date_dim	73,049	11MB
4	warehouse	20	1200KB
5	ship_mode	20	864KB
6	time_dim	86,400	1520KB
7	reason	65	720KB
8	income_band	20	720KB
9	item	300,000	23MB
10	store	1,002	2400KB
11	call_center	42	1968KB
12	customer	12,000,000	519MB
13	web_site	54	1824KB
14	household_demographics	7,200	1208KB
15	web_page	3,000	2208KB
16	promotion	1,500	2112KB
17	catalog_page	30,000	3536KB
18	inventory	783,000,000	2499MB
19	catalog_returns	143,996,756	8454MB
20	web_returns	71,997,522	3990MB
21	store_returns	287,999,764	13GB
22	web_sales	720,000,376	54GB
23	catalog_sales	1,439,980,416	104GB
24	store_sales	2,879,987,999	142GB