Borker Load 导入导出性能测试

测试环境

机器配置

在这里插入图片描述

FIO测试



starrocks: (g=0): rw=write, bs=(R) 8192B-8192B, (W) 8192B-8192B, (T) 8192B-8192B, ioengine=psync, iodepth=1
fio-3.7
Starting 1 process
starrocks: Laying out IO file (1 file / 10240MiB)
Jobs: 1 (f=1): [W(1)][100.0%][r=0KiB/s,w=6232KiB/s][r=0,w=779 IOPS][eta 00m:00s]
starrocks: (groupid=0, jobs=1): err= 0: pid=18050: Thu Feb 17 15:01:01 2022
  write: IOPS=789, BW=6314KiB/s (6466kB/s)(370MiB/60001msec)
    clat (usec): min=6, max=2415, avg=13.37, stdev=51.60
     lat (usec): min=6, max=2416, avg=13.56, stdev=51.61
    clat percentiles (usec):
     |  1.00th=[    8],  5.00th=[    8], 10.00th=[    8], 20.00th=[    9],
     | 30.00th=[    9], 40.00th=[   10], 50.00th=[   10], 60.00th=[   11],
     | 70.00th=[   12], 80.00th=[   13], 90.00th=[   15], 95.00th=[   18],
     | 99.00th=[   24], 99.50th=[   27], 99.90th=[  832], 99.95th=[  963],
     | 99.99th=[ 2040]
   bw (  KiB/s): min= 3696, max= 6528, per=100.00%, avg=6313.89, stdev=278.36, samples=120
   iops        : min=  462, max=  816, avg=789.25, stdev=34.80, samples=120
  lat (usec)   : 10=55.38%, 20=41.83%, 50=2.47%, 100=0.01%, 250=0.01%
  lat (usec)   : 500=0.01%, 750=0.01%, 1000=0.24%
  lat (msec)   : 2=0.03%, 4=0.01%
  fsync/fdatasync/sync_file_range:
    sync (usec): min=845, max=68060, avg=1252.20, stdev=507.46
    sync percentiles (usec):
     |  1.00th=[ 1156],  5.00th=[ 1156], 10.00th=[ 1156], 20.00th=[ 1172],
     | 30.00th=[ 1172], 40.00th=[ 1172], 50.00th=[ 1188], 60.00th=[ 1188],
     | 70.00th=[ 1205], 80.00th=[ 1270], 90.00th=[ 1336], 95.00th=[ 1500],
     | 99.00th=[ 2343], 99.50th=[ 2540], 99.90th=[ 4178], 99.95th=[ 5276],
     | 99.99th=[21890]
  cpu          : usr=0.17%, sys=2.29%, ctx=95588, majf=0, minf=36
  IO depths    : 1=200.0%, 2=0.0%, 4=0.0%, 8=0.0%, 16=0.0%, 32=0.0%, >=64=0.0%
     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     complete  : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
     issued rwts: total=0,47356,0,0 short=47356,0,0,0 dropped=0,0,0,0
     latency   : target=0, window=0, percentile=100.00%, depth=1

Run status group 0 (all jobs):
  WRITE: bw=6314KiB/s (6466kB/s), 6314KiB/s-6314KiB/s (6466kB/s-6466kB/s), io=370MiB (388MB), run=60001-60001msec

Disk stats (read/write):
  vdb: ios=142/143978, merge=0/99169, ticks=316/63247, in_queue=42906, util=62.55%

StarRocks 集群信息

在这里插入图片描述

HDFS 集群信息

在这里插入图片描述

测试模型

测试采用 TPCH 50G 测试集

测试模型信息

在这里插入图片描述

表结构及数据

表结构
drop table if exists customer;
CREATE TABLE customer (
    c_custkey     int NOT NULL,
    c_name        VARCHAR(25) NOT NULL,
    c_address     VARCHAR(40) NOT NULL,
    c_nationkey   int NOT NULL,
    c_phone       VARCHAR(15) NOT NULL,
    c_acctbal     decimal(15, 2)   NOT NULL,
    c_mktsegment  VARCHAR(10) NOT NULL,
    c_comment     VARCHAR(117) NOT NULL
)ENGINE=OLAP
DUPLICATE KEY(`c_custkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 24
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);


drop table if exists lineitem;
CREATE TABLE lineitem ( 
    l_shipdate    DATE ,
    l_orderkey    int ,
    l_linenumber  int ,
    l_partkey     int ,
    l_suppkey     int ,
    l_quantity    decimal(15, 2) ,
    l_extendedprice  decimal(15, 2) ,
    l_discount    decimal(15, 2) ,
    l_tax         decimal(15, 2) ,
    l_returnflag  VARCHAR(1) ,
    l_linestatus  VARCHAR(1) ,
    l_commitdate  DATE ,
    l_receiptdate DATE ,
    l_shipinstruct VARCHAR(25) ,
    l_shipmode     VARCHAR(10) ,
    l_comment      VARCHAR(44) 
)ENGINE=OLAP
DUPLICATE KEY(`l_shipdate`, `l_orderkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`l_orderkey`) BUCKETS 96
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);


drop table if exists nation;
CREATE TABLE `nation` (
  `n_nationkey` int(11) NOT NULL,
  `n_name`      varchar(25) NOT NULL,
  `n_regionkey` int(11) NOT NULL,
  `n_comment`   varchar(152) NULL
) ENGINE=OLAP
DUPLICATE KEY(`N_NATIONKEY`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`N_NATIONKEY`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);


drop table if exists orders;
CREATE TABLE orders  (
    o_orderkey       int ,
    o_orderdate      DATE ,
    o_custkey        int ,
    o_orderstatus    VARCHAR(1) ,
    o_totalprice     decimal(15, 2) ,
    o_orderpriority  VARCHAR(15) ,
    o_clerk          VARCHAR(15) ,
    o_shippriority   int ,
    o_comment        VARCHAR(79) 
)ENGINE=OLAP
DUPLICATE KEY(`o_orderkey`, `o_orderdate`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`o_orderkey`) BUCKETS 96
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);


drop table if exists part;
CREATE TABLE part (
    p_partkey          int NOT NULL,
    p_name        VARCHAR(55) NOT NULL,
    p_mfgr        VARCHAR(25) NOT NULL,
    p_brand       VARCHAR(10) NOT NULL,
    p_type        VARCHAR(25) NOT NULL,
    p_size        int NOT NULL,
    p_container   VARCHAR(10) NOT NULL,
    p_retailprice decimal(15, 2) NOT NULL,
    p_comment     VARCHAR(23) NOT NULL
)ENGINE=OLAP
DUPLICATE KEY(`p_partkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 24
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);


drop table if exists partsupp;
CREATE TABLE partsupp ( 
    ps_partkey          int NOT NULL,
    ps_suppkey     int NOT NULL,
    ps_availqty    int NOT NULL,
    ps_supplycost  decimal(15, 2)  NOT NULL,
    ps_comment     VARCHAR(199) NOT NULL
)ENGINE=OLAP
DUPLICATE KEY(`ps_partkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`ps_partkey`) BUCKETS 24
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);


drop table if exists region;
CREATE TABLE region  ( 
    r_regionkey      int NOT NULL,
    r_name       VARCHAR(25) NOT NULL,
    r_comment    VARCHAR(152)
)ENGINE=OLAP
DUPLICATE KEY(`r_regionkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`r_regionkey`) BUCKETS 1
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);


drop table if exists supplier;
CREATE TABLE supplier (  
    s_suppkey       int NOT NULL,
    s_name        VARCHAR(25) NOT NULL,
    s_address     VARCHAR(40) NOT NULL,
    s_nationkey   int NOT NULL,
    s_phone       VARCHAR(15) NOT NULL,
    s_acctbal     decimal(15, 2) NOT NULL,
    s_comment     VARCHAR(101) NOT NULL
)ENGINE=OLAP
DUPLICATE KEY(`s_suppkey`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 12
PROPERTIES (
    "replication_num" = "3",
    "in_memory" = "false",
    "storage_format" = "DEFAULT"
);
数据示例

select * from customer limit 10 ;
+-----------+--------------------+------------------------------------------+-------------+-----------------+-----------+--------------+---------------------------------------------------------------------------------------------------------+
| c_custkey | c_name             | c_address                                | c_nationkey | c_phone         | c_acctbal | c_mktsegment | c_comment                                                                                               |
+-----------+--------------------+------------------------------------------+-------------+-----------------+-----------+--------------+---------------------------------------------------------------------------------------------------------+
|        36 | Customer#000000036 | 3TvCzjuPzpJ0,DdJ8kW5U                    |          21 | 31-704-669-5769 |   4987.27 | BUILDING     | haggle. enticing, quiet platelets grow quickly bold sheaves. carefully regular acc                      |
|        74 | Customer#000000074 | IkJHCA3ZThF7qL7VKcrU nRLl,kylf           |           4 | 14-199-862-7209 |   2764.43 | MACHINERY    | onic accounts. blithely slow packages would haggle carefully. qui                                       |
|        82 | Customer#000000082 | zhG3EZbap4c992Gj3bK,3Ne,Xn               |          18 | 28-159-442-5305 |   9468.34 | AUTOMOBILE   | s wake. bravely regular accounts are furiously. regula                                                  |
|       113 | Customer#000000113 | eaOl5UBXIvdY57rglaIzqvfPD,MYfK           |          12 | 22-302-930-4756 |      2912 | BUILDING     | usly regular theodolites boost furiously doggedly pending instructio                                    |
|       137 | Customer#000000137 | cdW91p92rlAEHgJafqYyxf1Q                 |          16 | 26-777-409-5654 |   7838.30 | HOUSEHOLD    | carefully regular theodolites use. silent dolphins cajo                                                 |
|       220 | Customer#000000220 | TbUHVhkttz                               |          16 | 26-201-301-7371 |   9131.64 | BUILDING     |  even, even accounts are. ironic                                                                        |
|       283 | Customer#000000283 | jysHDuTKUKYEjdBhtI LqTttTp 7i2kvx1 O3A   |           7 | 17-111-303-1282 |   4450.03 | AUTOMOBILE   | y alongside of the accounts. slyly express dependencies wake quickly above the carefully ironic package |
|       288 | Customer#000000288 | eEs5rwc9AOJaKhvV                         |           2 | 12-674-136-5397 |   5339.43 | HOUSEHOLD    |  furiously about the carefully ironic packages. express reques                                          |
|       373 | Customer#000000373 | 2hrQ wHkbaNlJCzY,mVkugMIE 8ryNlaA3JHDTjJ |          20 | 30-883-170-4010 |   2354.06 | MACHINERY    | requests wake blithely even packages. slyly ironic deposits haggle blithely                             |
|       377 | Customer#000000377 | PA4levhyD,Rvr0JHQ4QNOqJ9gW YXE           |          23 | 33-260-610-4079 |   1043.72 | MACHINERY    | . slyly regular ideas cajole blithely. slyly ironic foxes are carefully after the thinly special accou  |
+-----------+--------------------+------------------------------------------+-------------+-----------------+-----------+--------------+---------------------------------------------------------------------------------------------------------+
select * from lineitem limit 10 ;
+------------+------------+--------------+-----------+-----------+------------+-----------------+------------+-------+--------------+--------------+--------------+---------------+-------------------+------------+-------------------------------------------+
| l_shipdate | l_orderkey | l_linenumber | l_partkey | l_suppkey | l_quantity | l_extendedprice | l_discount | l_tax | l_returnflag | l_linestatus | l_commitdate | l_receiptdate | l_shipinstruct    | l_shipmode | l_comment                                 |
+------------+------------+--------------+-----------+-----------+------------+-----------------+------------+-------+--------------+--------------+--------------+---------------+-------------------+------------+-------------------------------------------+
| NULL       |         10 |       250011 |         5 |        16 |   14560.16 |            0.06 |       0.08 |  NULL | O            | NULL         | 1996-02-09   | 1996-03-26    | COLLECT COD       | FOB        | re slyly carefu                           |
| NULL       |         10 |       250011 |         5 |         5 |    4550.05 |            0.01 |       0.07 |  NULL | F            | NULL         | 1992-07-31   | 1992-08-20    | DELIVER IN PERSON | REG AIR    | n, final deposits wake slyly blithe       |
| NULL       |         10 |       125011 |         1 |        30 |   27300.30 |            0.06 |       0.04 |  NULL | F            | NULL         | 1992-06-18   | 1992-09-15    | COLLECT COD       | AIR        | ely silent foxes                          |
| NULL       |         10 |       125011 |         4 |        33 |   30030.33 |            0.08 |       0.01 |  NULL | O            | NULL         | 1995-08-29   | 1995-08-25    | NONE              | MAIL       | gularly expre                             |
| NULL       |         10 |       250011 |         5 |        45 |   40950.45 |            0.05 |       0.02 |  NULL | O            | NULL         | 1997-11-15   | 1997-10-23    | TAKE BACK RETURN  | RAIL       | pths sleep along th                       |
| NULL       |         10 |       375011 |         6 |        38 |   34580.38 |            0.01 |       0.01 |  NULL | F            | NULL         | 1993-10-28   | 1993-11-23    | TAKE BACK RETURN  | AIR        | the warhorses nag enticingly at th        |
| NULL       |         10 |       125011 |         1 |        44 |   40040.44 |            0.02 |       0.01 |  NULL | O            | NULL         | 1998-03-22   | 1998-02-11    | DELIVER IN PERSON | RAIL       |  packages. careful                        |
| NULL       |         10 |       250011 |         3 |        41 |   37310.41 |            0.05 |       0.04 |  NULL | O            | NULL         | 1997-02-19   | 1997-05-20    | NONE              | AIR        | ts poach. carefully darin                 |
| NULL       |         10 |       375011 |         6 |        10 |    9100.10 |               0 |       0.06 |  NULL | F            | NULL         | 1992-09-10   | 1992-11-08    | NONE              | AIR        | ites nag slyly alongside of th            |
| NULL       |         10 |           11 |         2 |         8 |    7280.08 |            0.05 |       0.01 |  NULL | F            | NULL         | 1992-07-20   | 1992-10-12    | COLLECT COD       | REG AIR    |  even instructions according to the furio |
+------------+------------+--------------+-----------+-----------+------------+-----------------+------------+-------+--------------+--------------+--------------+---------------+-------------------+------------+-------------------------------------------+
select * from nation limit 10 ;
+-------------+-----------+-------------+--------------------------------------------------------------------------------------------------------------------+
| n_nationkey | n_name    | n_regionkey | n_comment                                                                                                          |
+-------------+-----------+-------------+--------------------------------------------------------------------------------------------------------------------+
|           0 | ALGERIA   |           0 |  haggle. carefully final deposits detect slyly agai                                                                |
|           1 | ARGENTINA |           1 | al foxes promise slyly according to the regular accounts. bold requests alon                                       |
|           2 | BRAZIL    |           1 | y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special         |
|           3 | CANADA    |           1 | eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold              |
|           4 | EGYPT     |           4 | y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d                |
|           5 | ETHIOPIA  |           0 | ven packages wake quickly. regu                                                                                    |
|           6 | FRANCE    |           3 | refully final requests. regular, ironi                                                                             |
|           7 | GERMANY   |           3 | l platelets. regular accounts x-ray: unusual, regular acco                                                         |
|           8 | INDIA     |           2 | ss excuses cajole slyly across the packages. deposits print aroun                                                  |
|           9 | INDONESIA |           2 |  slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull |
+-------------+-----------+-------------+--------------------------------------------------------------------------------------------------------------------+
select * from orders limit 10 ;
+------------+-------------+-----------+---------------+--------------+-----------------+-----------------+----------------+---------------------------------------------------------------------------+
| o_orderkey | o_orderdate | o_custkey | o_orderstatus | o_totalprice | o_orderpriority | o_clerk         | o_shippriority | o_comment                                                                 |
+------------+-------------+-----------+---------------+--------------+-----------------+-----------------+----------------+---------------------------------------------------------------------------+
|        257 | NULL        |      NULL | NULL          |         NULL | 3-MEDIUM        | Clerk#000033957 |              0 | ts against the sly warhorses cajole slyly accounts                        |
|        416 | NULL        |      NULL | NULL          |         NULL | 5-LOW           | Clerk#000014654 |              0 |  the accounts. fluffily bold depo                                         |
|       1796 | NULL        |      NULL | NULL          |         NULL | 2-HIGH          | Clerk#000012214 |              0 | eans use furiously around th                                              |
|       2116 | 2011-10-31  |      NULL | NULL          |         NULL | 1-URGENT        | Clerk#000009818 |              0 | efully after the asymptotes. furiously sp                                 |
|       2368 | NULL        |      NULL | NULL          |         NULL | 1-URGENT        | Clerk#000041456 |              0 | t the bold instructions. carefully unusual                                |
|       2883 | NULL        |      NULL | NULL          |         NULL | 5-LOW           | Clerk#000008993 |              0 | uses. carefully ironic accounts lose fluffil                              |
|       3042 | NULL        |      NULL | NULL          |         NULL | 3-MEDIUM        | Clerk#000028617 |              0 |  the slyly ironic depo                                                    |
|       3138 | NULL        |      NULL | NULL          |         NULL | 4-NOT SPECIFIED | Clerk#000032457 |              0 | e fluffily final theodolites. even dependencies wake along the quickly ir |
|       3398 | NULL        |      NULL | NULL          |         NULL | 1-URGENT        | Clerk#000040887 |              0 | uthless, special courts atop the unusual accounts grow fur                |
|       3649 | NULL        |      NULL | NULL          |         NULL | 5-LOW           | Clerk#000017435 |              0 | taphs boost above the final p                                             |
+------------+-------------+-----------+---------------+--------------+-----------------+-----------------+----------------+---------------------------------------------------------------------------+
select * from part limit 10 ;
+-----------+---------------------------------------+----------------+----------+---------------------------+--------+-------------+---------------+-----------------------+
| p_partkey | p_name                                | p_mfgr         | p_brand  | p_type                    | p_size | p_container | p_retailprice | p_comment             |
+-----------+---------------------------------------+----------------+----------+---------------------------+--------+-------------+---------------+-----------------------+
|        30 | cream misty steel spring medium       | Manufacturer#4 | Brand#42 | PROMO ANODIZED TIN        |     17 | LG BOX      |        930.03 | carefully bus         |
|        61 | light tan linen tomato peach          | Manufacturer#5 | Brand#54 | SMALL BURNISHED NICKEL    |     18 | WRAP DRUM   |        961.06 | es. blithely en       |
|        71 | violet firebrick cream peru white     | Manufacturer#3 | Brand#33 | STANDARD PLATED BRASS     |     26 | WRAP DRUM   |        971.07 |  packages alongside   |
|       100 | cyan orchid indian cornflower saddle  | Manufacturer#3 | Brand#33 | ECONOMY ANODIZED TIN      |      4 | LG BAG      |       1000.10 | of the steal          |
|       124 | wheat blush forest metallic navajo    | Manufacturer#3 | Brand#32 | PROMO ANODIZED STEEL      |      1 | LG BOX      |       1024.12 | g the expr            |
|       144 | hot midnight orchid dim steel         | Manufacturer#1 | Brand#14 | SMALL ANODIZED TIN        |     26 | SM BOX      |       1044.14 | owly                  |
|       156 | almond ghost powder blush forest      | Manufacturer#4 | Brand#43 | SMALL POLISHED NICKEL     |      2 | LG PKG      |       1056.15 |  pinto beans. eve     |
|       171 | beige violet black magenta chartreuse | Manufacturer#1 | Brand#11 | STANDARD BURNISHED COPPER |     40 | LG JAR      |       1071.17 |  the r                |
|       179 | deep puff brown blue burlywood        | Manufacturer#4 | Brand#43 | ECONOMY BRUSHED STEEL     |     20 | LG JAR      |       1079.17 | ely regul             |
|       197 | lawn lemon khaki rosy blue            | Manufacturer#5 | Brand#52 | SMALL ANODIZED COPPER     |     18 | SM JAR      |       1097.19 | lithely after the eve |
+-----------+---------------------------------------+----------------+----------+---------------------------+--------+-------------+---------------+-----------------------+
select * from partsupp limit 10 ;
+------------+------------+-------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ps_partkey | ps_suppkey | ps_availqty | ps_supplycost | ps_comment                                                                                                                                                     |
+------------+------------+-------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
|         36 |         37 |        3907 |        630.91 | al deposits detect fluffily fluffily unusual sauternes. carefully regular requests against the car                                                             |
|         36 |     125037 |         174 |        434.47 | permanently express instructions. unusual accounts nag toward the accou                                                                                        |
|         36 |     250037 |        2625 |        569.91 | ctions. pending requests are fluffily across the furiously regular notornis. unusu                                                                             |
|         36 |     375037 |        8209 |        289.15 | arefully regular requests cajole. special, express foxes sleep slowly. quickly unusual in                                                                      |
|         74 |         75 |        3128 |        345.92 | ic theodolites. express deposits haggle blithely pending packages. quickly express foxes could are slyly. deposits sleep deposits. final dependencies sleep ab |
|         74 |     125075 |        2479 |        930.97 | o beans sleep dependencies. regular accounts use blithely asymptotes. u                                                                                        |
|         74 |     250075 |        9473 |        496.36 |  haggle carefully alongside of the regular requests. slyly regular accounts belie                                                                              |
|         74 |     375075 |        6234 |        849.66 |  slyly regular foxes. silent accounts integrate. even deposits are quick                                                                                       |
|         82 |         83 |        7793 |        697.31 | he accounts cajole quickly after the even patterns. ironic platelets sublate regular, even asymptotes. quick courts affix according to                         |
|         82 |     125083 |        7698 |        585.86 | pinto beans. slyly express excuses haggle. blithely even pinto beans about the quick inst                                                                      |
+------------+------------+-------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
select * from region limit 10 ;
+-------------+-------------+---------------------------------------------------------------------------------------------------------------------+
| r_regionkey | r_name      | r_comment                                                                                                           |
+-------------+-------------+---------------------------------------------------------------------------------------------------------------------+
|           0 | AFRICA      | lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to  |
|           1 | AMERICA     | hs use ironic, even requests. s                                                                                     |
|           2 | ASIA        | ges. thinly even pinto beans ca                                                                                     |
|           3 | EUROPE      | ly final courts cajole furiously final excuse                                                                       |
|           4 | MIDDLE EAST | uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl        |
+-------------+-------------+---------------------------------------------------------------------------------------------------------------------+
select * from supplier limit 10 ;
+-----------+--------------------+------------------------------------------+-------------+-----------------+-----------+---------------------------------------------------------------------------------------------------+
| s_suppkey | s_name             | s_address                                | s_nationkey | s_phone         | s_acctbal | s_comment                                                                                         |
+-----------+--------------------+------------------------------------------+-------------+-----------------+-----------+---------------------------------------------------------------------------------------------------+
|         1 | Supplier#000000001 |  N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ      |          17 | 27-918-335-1736 |   5755.94 | each slyly above the careful                                                                      |
|        13 | Supplier#000000013 | HK71HQyWoqRWOX8GI FpgAifW,2PoH           |           3 | 13-727-620-7813 |   9107.22 | requests engage regularly instructions. furiously special requests ar                             |
|        34 | Supplier#000000034 | mYRe3KvA2O4lL4HhxDKkkrPUDPMKRCSp,Xpa     |          10 | 20-519-982-2343 |    237.31 | eposits. slyly final deposits toward the slyly regular dependencies sleep among the excu          |
|        36 | Supplier#000000036 | mzSpBBJvbjdx3UKTW3bLFewRD78D91lAC879     |          13 | 23-273-493-3679 |   2371.51 | ular theodolites must haggle regular, bold accounts. slyly final pinto beans bo                   |
|        74 | Supplier#000000074 | uM3yV5NOc6b5wNdpxF69CW 8QvDxqvKubRJtA    |          20 | 30-166-486-1559 |   4170.51 | carefully along the quickly regular sentiments. ironic accounts sleep. regular deposits are blith |
|        76 | Supplier#000000076 | JBhSBa3cLYvNgHUYtUHmtECCD                |          14 | 24-228-763-7840 |   2971.10 | , even instructions. furiously unusual deposits wake slyly about the ev                           |
|        82 | Supplier#000000082 | WyTKA7ZpF15t1aCNlT3                      |          18 | 28-177-572-9691 |   -724.31 | xpress multipliers wake furiously even foxes. furiously iro                                       |
|        84 | Supplier#000000084 | DcYjWMiZGQqEKOJi4wAmIV08ikx              |          24 | 34-869-118-7803 |   4780.93 | even depths. regular foxes use slyly. theod                                                       |
|       111 | Supplier#000000111 | uv56H9j8cNa4qnflVSYbLNN                  |           4 | 14-256-573-2660 |   6578.65 | ing theodolites are about the slowly pending                                                      |
|       113 | Supplier#000000113 | 5 YOpqbaHs7dR gG4EmXrI7XtA7DcnRMsWPU1z2D |          11 | 21-211-117-1937 |   1882.05 | blithely regular courts wake quickly even pl                                                      |
+-----------+--------------------+------------------------------------------+-------------+-----------------+-----------+---------------------------------------------------------------------------------------------------+

性能测试

Stream Load 导入性能


在这里插入图片描述在这里插入图片描述

HDFS 备份性能

将 TPCH 的测试表备份到 HDFS 集群
在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值