dingjing0604 commented on issue #8141:
URL:
https://github.com/apache/incubator-doris/issues/8141#issuecomment-1046056914
> 你建表的时候的tablet 数目是多少呢？
1. 8个表。load之前的数据大小：
-rw-r--r-- 1 root root 2.3G Jan 27 20:16 customer.csv
-rw-r--r-- 1 root root 74G Jan 27 20:30 lineitem.csv
-rw-r--r-- 1 root root 2.2K Jan 27 20:30 nation.csv
-rw-r--r-- 1 root root 17G Jan 27 20:33 orders.csv
-rw-r--r-- 1 root root 2.3G Jan 27 20:35 part.csv
-rw-r--r-- 1 root root 12G Jan 27 20:34 partsupp.csv
-rw-r--r-- 1 root root 384 Jan 27 20:35 region.csv
-rw-r--r-- 1 root root 136M Jan 27 20:35 supplier.csv
2. 建表语句
CREATE TABLE `customer` (
`C_CUSTKEY` int(11) NOT NULL,
`C_NAME` varchar(25) NOT NULL,
`C_ADDRESS` varchar(40) NOT NULL,
`C_NATIONKEY` int(11) NOT NULL,
`C_PHONE` varchar(15) NOT NULL,
`C_ACCTBAL` decimal(12,2) NOT NULL,
`C_MKTSEGMENT` varchar(10) NOT NULL,
`C_COMMENT` varchar(117) NOT NULL
)
DISTRIBUTED BY HASH(C_CUSTKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
CREATE TABLE `lineitem` (
`L_ORDERKEY` bigint(20) NOT NULL,
`L_PARTKEY` int(11) NOT NULL,
`L_SUPPKEY` int(11) NOT NULL,
`L_LINENUMBER` bigint(20) NOT NULL,
`L_QUANTITY` decimal(12,2) NOT NULL,
`L_EXTENDEDPRICE` decimal(12,2) NOT NULL,
`L_DISCOUNT` decimal(12,2) NOT NULL,
`L_TAX` decimal(12,2) NOT NULL,
`L_RETURNFLAG` varchar(1) NOT NULL,
`L_LINESTATUS` varchar(1) NOT NULL,
`L_SHIPDATE` date NOT NULL,
`L_COMMITDATE` date NOT NULL,
`L_RECEIPTDATE` date NOT NULL,
`L_SHIPINSTRUCT` varchar(25) NOT NULL,
`L_SHIPMODE` varchar(10) NOT NULL,
`L_COMMENT` varchar(44) NOT NULL
)
DISTRIBUTED BY HASH(L_ORDERKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
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) DEFAULT NULL
)
DISTRIBUTED BY HASH(N_NATIONKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
CREATE TABLE `orders` (
`O_ORDERKEY` bigint(20) NOT NULL,
`O_CUSTKEY` int(11) NOT NULL,
`O_ORDERSTATUS` varchar(1) NOT NULL,
`O_TOTALPRICE` decimal(12,2) NOT NULL,
`O_ORDERDATE` date NOT NULL,
`O_ORDERPRIORITY` varchar(15) NOT NULL,
`O_CLERK` varchar(15) NOT NULL,
`O_SHIPPRIORITY` int(11) NOT NULL,
`O_COMMENT` varchar(79) NOT NULL
)
DISTRIBUTED BY HASH(O_ORDERKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
CREATE TABLE `part` (
`P_PARTKEY` int(11) 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(11) NOT NULL,
`P_CONTAINER` varchar(10) NOT NULL,
`P_RETAILPRICE` decimal(12,2) NOT NULL,
`P_COMMENT` varchar(23) NOT NULL
)
DISTRIBUTED BY HASH(P_PARTKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
CREATE TABLE `partsupp` (
`PS_PARTKEY` int(11) NOT NULL,
`PS_SUPPKEY` int(11) NOT NULL,
`PS_AVAILQTY` int(11) NOT NULL,
`PS_SUPPLYCOST` decimal(12,2) NOT NULL,
`PS_COMMENT` varchar(199) NOT NULL
)
DISTRIBUTED BY HASH(PS_PARTKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
CREATE TABLE `region` (
`R_REGIONKEY` int(11) NOT NULL,
`R_NAME` varchar(25) NOT NULL,
`R_COMMENT` varchar(152) DEFAULT NULL
)
DISTRIBUTED BY HASH(R_REGIONKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
CREATE TABLE `supplier` (
`S_SUPPKEY` int(11) NOT NULL,
`S_NAME` varchar(25) NOT NULL,
`S_ADDRESS` varchar(40) NOT NULL,
`S_NATIONKEY` int(11) NOT NULL,
`S_PHONE` varchar(15) NOT NULL,
`S_ACCTBAL` decimal(12,2) NOT NULL,
`S_COMMENT` varchar(101) NOT NULL
)
DISTRIBUTED BY HASH(S_SUPPKEY) BUCKETS 10
PROPERTIES("replication_num" = "1");
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
