CREATE TABLE "WUTONG_FUND"."fund_nav_pfm"
             (
                          "trading_date"            DATE NOT NULL,
                          "fund_code"               VARCHAR(20) NOT NULL,
                          "nav"                     DECIMAL(20,8) NULL,
                          "accumulative_nav"        DECIMAL(20,8) NULL,
                          "nav_growth_rate"         DECIMAL(20,8) NULL,
                          "accumulative_nav_growth" DECIMAL(20,8) NULL,
                          "adjust_factor"           DECIMAL(20,8) NULL,
                          "acc_adjust_factor"       DECIMAL(20,8) NULL,
                          "adjusted_nav"            DECIMAL(22,8) NULL,
                          "adjusted_nav_growth"     DECIMAL(20,8) NULL,
                          "risk_premium"            DECIMAL(20,8) NULL,
                          "update_time"             TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NULL
             )
PARTITION BY RANGE 
             ( 
                          "trading_date" 
             )
             INTERVAL 
             ( 
                          NUMTOYMINTERVAL(1,'year') 
             )
             (
             PARTITION "p2000" VALUES LESS THAN ('2000-01-01') ,
             PARTITION "p2001" VALUES LESS THAN ('2001-01-01') ,
             PARTITION "p2002" VALUES LESS THAN ('2002-01-01') ,
             PARTITION "p2003" VALUES LESS THAN ('2003-01-01') ,
             PARTITION "p2004" VALUES LESS THAN ('2004-01-01') ,
             PARTITION "p2005" VALUES LESS THAN ('2005-01-01') ,
             PARTITION "p2006" VALUES LESS THAN ('2006-01-01') ,
             PARTITION "p2007" VALUES LESS THAN ('2007-01-01') ,
             PARTITION "p2008" VALUES LESS THAN ('2008-01-01') ,
             PARTITION "p2009" VALUES LESS THAN ('2009-01-01') ,
             PARTITION "p2010" VALUES LESS THAN ('2010-01-01') ,
             PARTITION "p2011" VALUES LESS THAN ('2011-01-01') ,
             PARTITION "p2012" VALUES LESS THAN ('2012-01-01') ,
             PARTITION "p2013" VALUES LESS THAN ('2013-01-01') ,
             PARTITION "p2014" VALUES LESS THAN ('2014-01-01') ,
             PARTITION "p2015" VALUES LESS THAN ('2015-01-01') ,
             PARTITION "p2016" VALUES LESS THAN ('2016-01-01') ,
             PARTITION "p2017" VALUES LESS THAN ('2017-01-01') ,
             PARTITION "p2018" VALUES LESS THAN ('2018-01-01') ,
             PARTITION "p2019" VALUES LESS THAN ('2019-01-01') ,
             PARTITION "p2020" VALUES LESS THAN ('2020-01-01') ,
             PARTITION "p2021" VALUES LESS THAN ('2021-01-01') ,
             PARTITION "p2022" VALUES LESS THAN ('2022-01-01') ,
             PARTITION "p2023" VALUES LESS THAN ('2023-01-01') ,
             PARTITION "p2024" VALUES LESS THAN ('2024-01-01') ,
             PARTITION "p2025" VALUES LESS THAN ('2025-01-01') ,
             PARTITION "p2026" VALUES LESS THAN ('2026-01-01') ,
             PARTITION "p2027" VALUES LESS THAN ('2027-01-01') 
             );

分区列为函数表达式时，使用虚拟列处理

CREATE
TABLE "fund_nav_pfm"
(
"trading_date" DATE NOT NULL ,
"fund_code" VARCHAR(20) NOT NULL,
"nav" DECIMAL(20, 8) NULL ,
"accumulative_nav" DECIMAL(20, 8) NULL ,
"nav_growth_rate" DECIMAL(20, 8) NULL ,
"accumulative_nav_growth" DECIMAL(20, 8) NULL ,
"adjust_factor" DECIMAL(20, 8) NULL ,
"acc_adjust_factor" DECIMAL(20, 8) NULL ,
"adjusted_nav" DECIMAL(22, 8) NULL ,
"adjusted_nav_growth" DECIMAL(20, 8) NULL ,
"risk_premium" DECIMAL(20, 8) NULL ,
"update_time" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NULL,
"year_trading_date" int as (year("trading_date"))
)
PARTITION BY RANGE
(
"year_trading_date"
)
(
PARTITION "p2000" VALUES LESS THAN (2000),
PARTITION "p2001" VALUES LESS THAN (2001),
PARTITION "p2002" VALUES LESS THAN (2002),
PARTITION "p2003" VALUES LESS THAN (2003),
PARTITION "p2004" VALUES LESS THAN (2004),
PARTITION "p2005" VALUES LESS THAN (2005),
PARTITION "p2006" VALUES LESS THAN (2006),
PARTITION "p2007" VALUES LESS THAN (2007),
PARTITION "p2008" VALUES LESS THAN (2008),
PARTITION "p2009" VALUES LESS THAN (2009),
PARTITION "p2010" VALUES LESS THAN (2010),
PARTITION "p2011" VALUES LESS THAN (2011),
PARTITION "p2012" VALUES LESS THAN (2012),
PARTITION "p2013" VALUES LESS THAN (2013),
PARTITION "p2014" VALUES LESS THAN (2014),
PARTITION "p2015" VALUES LESS THAN (2015),
PARTITION "p2016" VALUES LESS THAN (2016),
PARTITION "p2017" VALUES LESS THAN (2017),
PARTITION "p2018" VALUES LESS THAN (2018),
PARTITION "p2019" VALUES LESS THAN (2019),
PARTITION "p2020" VALUES LESS THAN (2020),
PARTITION "p2021" VALUES LESS THAN (2021),
PARTITION "p2022" VALUES LESS THAN (2022),
PARTITION "p2023" VALUES LESS THAN (2023),
PARTITION "p2024" VALUES LESS THAN (2024),
PARTITION "p2025" VALUES LESS THAN (2025),
PARTITION "p2026" VALUES LESS THAN (2026),
PARTITION "p2027" VALUES LESS THAN (2027)
)