This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new 6a89b89 [refactor](benchmark) Change SSB create table column to NOT
NULL (#7898)
6a89b89 is described below
commit 6a89b893a3f537f29ecde4025ae6eb7a5652d8a1
Author: HappenLee <[email protected]>
AuthorDate: Fri Jan 28 22:26:55 2022 +0800
[refactor](benchmark) Change SSB create table column to NOT NULL (#7898)
---
tools/ssb-tools/create-tables.sql | 116 +++++++++++++++++++-------------------
1 file changed, 58 insertions(+), 58 deletions(-)
diff --git a/tools/ssb-tools/create-tables.sql
b/tools/ssb-tools/create-tables.sql
index fc971b1..5e99f89 100644
--- a/tools/ssb-tools/create-tables.sql
+++ b/tools/ssb-tools/create-tables.sql
@@ -16,23 +16,23 @@
-- under the License.
CREATE TABLE `lineorder` (
- `lo_orderkey` bigint(20) NULL COMMENT "",
- `lo_linenumber` bigint(20) NULL COMMENT "",
- `lo_custkey` int(11) NULL COMMENT "",
- `lo_partkey` int(11) NULL COMMENT "",
- `lo_suppkey` int(11) NULL COMMENT "",
- `lo_orderdate` int(11) NULL COMMENT "",
- `lo_orderpriority` varchar(16) NULL COMMENT "",
- `lo_shippriority` int(11) NULL COMMENT "",
- `lo_quantity` bigint(20) NULL COMMENT "",
- `lo_extendedprice` bigint(20) NULL COMMENT "",
- `lo_ordtotalprice` bigint(20) NULL COMMENT "",
- `lo_discount` bigint(20) NULL COMMENT "",
- `lo_revenue` bigint(20) NULL COMMENT "",
- `lo_supplycost` bigint(20) NULL COMMENT "",
- `lo_tax` bigint(20) NULL COMMENT "",
- `lo_commitdate` bigint(20) NULL COMMENT "",
- `lo_shipmode` varchar(11) NULL COMMENT ""
+ `lo_orderkey` bigint(20) NOT NULL COMMENT "",
+ `lo_linenumber` bigint(20) NOT NULL COMMENT "",
+ `lo_custkey` int(11) NOT NULL COMMENT "",
+ `lo_partkey` int(11) NOT NULL COMMENT "",
+ `lo_suppkey` int(11) NOT NULL COMMENT "",
+ `lo_orderdate` int(11) NOT NULL COMMENT "",
+ `lo_orderpriority` varchar(16) NOT NULL COMMENT "",
+ `lo_shippriority` int(11) NOT NULL COMMENT "",
+ `lo_quantity` bigint(20) NOT NULL COMMENT "",
+ `lo_extendedprice` bigint(20) NOT NULL COMMENT "",
+ `lo_ordtotalprice` bigint(20) NOT NULL COMMENT "",
+ `lo_discount` bigint(20) NOT NULL COMMENT "",
+ `lo_revenue` bigint(20) NOT NULL COMMENT "",
+ `lo_supplycost` bigint(20) NOT NULL COMMENT "",
+ `lo_tax` bigint(20) NOT NULL COMMENT "",
+ `lo_commitdate` bigint(20) NOT NULL COMMENT "",
+ `lo_shipmode` varchar(11) NOT NULL COMMENT ""
)
PARTITION BY RANGE(`lo_orderdate`)
(PARTITION p1992 VALUES [("-2147483648"), ("19930101")),
@@ -48,14 +48,14 @@ PROPERTIES (
);
CREATE TABLE `customer` (
- `c_custkey` int(11) NULL COMMENT "",
- `c_name` varchar(26) NULL COMMENT "",
- `c_address` varchar(41) NULL COMMENT "",
- `c_city` varchar(11) NULL COMMENT "",
- `c_nation` varchar(16) NULL COMMENT "",
- `c_region` varchar(13) NULL COMMENT "",
- `c_phone` varchar(16) NULL COMMENT "",
- `c_mktsegment` varchar(11) NULL COMMENT ""
+ `c_custkey` int(11) NOT NULL COMMENT "",
+ `c_name` varchar(26) NOT NULL COMMENT "",
+ `c_address` varchar(41) NOT NULL COMMENT "",
+ `c_city` varchar(11) NOT NULL COMMENT "",
+ `c_nation` varchar(16) NOT NULL COMMENT "",
+ `c_region` varchar(13) NOT NULL COMMENT "",
+ `c_phone` varchar(16) NOT NULL COMMENT "",
+ `c_mktsegment` varchar(11) NOT NULL COMMENT ""
)
DISTRIBUTED BY HASH(`c_custkey`) BUCKETS 10
PROPERTIES (
@@ -63,23 +63,23 @@ PROPERTIES (
);
CREATE TABLE `date` (
- `d_datekey` int(11) NULL COMMENT "",
- `d_date` varchar(20) NULL COMMENT "",
- `d_dayofweek` varchar(10) NULL COMMENT "",
- `d_month` varchar(11) NULL COMMENT "",
- `d_year` int(11) NULL COMMENT "",
- `d_yearmonthnum` int(11) NULL COMMENT "",
- `d_yearmonth` varchar(9) NULL COMMENT "",
- `d_daynuminweek` int(11) NULL COMMENT "",
- `d_daynuminmonth` int(11) NULL COMMENT "",
- `d_daynuminyear` int(11) NULL COMMENT "",
- `d_monthnuminyear` int(11) NULL COMMENT "",
- `d_weeknuminyear` int(11) NULL COMMENT "",
- `d_sellingseason` varchar(14) NULL COMMENT "",
- `d_lastdayinweekfl` int(11) NULL COMMENT "",
- `d_lastdayinmonthfl` int(11) NULL COMMENT "",
- `d_holidayfl` int(11) NULL COMMENT "",
- `d_weekdayfl` int(11) NULL COMMENT ""
+ `d_datekey` int(11) NOT NULL COMMENT "",
+ `d_date` varchar(20) NOT NULL COMMENT "",
+ `d_dayofweek` varchar(10) NOT NULL COMMENT "",
+ `d_month` varchar(11) NOT NULL COMMENT "",
+ `d_year` int(11) NOT NULL COMMENT "",
+ `d_yearmonthnum` int(11) NOT NULL COMMENT "",
+ `d_yearmonth` varchar(9) NOT NULL COMMENT "",
+ `d_daynuminweek` int(11) NOT NULL COMMENT "",
+ `d_daynuminmonth` int(11) NOT NULL COMMENT "",
+ `d_daynuminyear` int(11) NOT NULL COMMENT "",
+ `d_monthnuminyear` int(11) NOT NULL COMMENT "",
+ `d_weeknuminyear` int(11) NOT NULL COMMENT "",
+ `d_sellingseason` varchar(14) NOT NULL COMMENT "",
+ `d_lastdayinweekfl` int(11) NOT NULL COMMENT "",
+ `d_lastdayinmonthfl` int(11) NOT NULL COMMENT "",
+ `d_holidayfl` int(11) NOT NULL COMMENT "",
+ `d_weekdayfl` int(11) NOT NULL COMMENT ""
)
DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1
PROPERTIES (
@@ -87,15 +87,15 @@ PROPERTIES (
);
CREATE TABLE `part` (
- `p_partkey` int(11) NULL COMMENT "",
- `p_name` varchar(23) NULL COMMENT "",
- `p_mfgr` varchar(7) NULL COMMENT "",
- `p_category` varchar(8) NULL COMMENT "",
- `p_brand` varchar(10) NULL COMMENT "",
- `p_color` varchar(12) NULL COMMENT "",
- `p_type` varchar(26) NULL COMMENT "",
- `p_size` int(11) NULL COMMENT "",
- `p_container` varchar(11) NULL COMMENT ""
+ `p_partkey` int(11) NOT NULL COMMENT "",
+ `p_name` varchar(23) NOT NULL COMMENT "",
+ `p_mfgr` varchar(7) NOT NULL COMMENT "",
+ `p_category` varchar(8) NOT NULL COMMENT "",
+ `p_brand` varchar(10) NOT NULL COMMENT "",
+ `p_color` varchar(12) NOT NULL COMMENT "",
+ `p_type` varchar(26) NOT NULL COMMENT "",
+ `p_size` int(11) NOT NULL COMMENT "",
+ `p_container` varchar(11) NOT NULL COMMENT ""
)
DISTRIBUTED BY HASH(`p_partkey`) BUCKETS 10
PROPERTIES (
@@ -103,13 +103,13 @@ PROPERTIES (
);
CREATE TABLE `supplier` (
- `s_suppkey` int(11) NULL COMMENT "",
- `s_name` varchar(26) NULL COMMENT "",
- `s_address` varchar(26) NULL COMMENT "",
- `s_city` varchar(11) NULL COMMENT "",
- `s_nation` varchar(16) NULL COMMENT "",
- `s_region` varchar(13) NULL COMMENT "",
- `s_phone` varchar(16) NULL COMMENT ""
+ `s_suppkey` int(11) NOT NULL COMMENT "",
+ `s_name` varchar(26) NOT NULL COMMENT "",
+ `s_address` varchar(26) NOT NULL COMMENT "",
+ `s_city` varchar(11) NOT NULL COMMENT "",
+ `s_nation` varchar(16) NOT NULL COMMENT "",
+ `s_region` varchar(13) NOT NULL COMMENT "",
+ `s_phone` varchar(16) NOT NULL COMMENT ""
)
DISTRIBUTED BY HASH(`s_suppkey`) BUCKETS 10
PROPERTIES (
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
