同步 DDL 支持的范围 创建表 CREATE TABLE 重要 包括分区表,不包括 ...如果 OceanBase 数据库 Oracle 租户中仅存在 NOT NULL UK,则不支持导致 OceanBase 数据库失去 NOT NULL UK 的 DDL 操作。存在 CASE WHEN INDEX 的建表 DDL 不支持同步。
PART表 CREATE TABLE part(p_partkey int NOT NULL COMMENT '',p_name varchar NOT NULL COMMENT '',p_mfgr varchar NOT NULL COMMENT '',p_brand varchar(10)NOT NULL COMMENT '',p_type varchar NOT NULL COMMENT '',p_size int NOT NULL...
修改列 NULLABLE 属性 MySQL 数据库 非约束情况下,支持通过 CHANGE/MODIFY COLUMN 将 NULLABLE 修改为 NOT NULL,支持修改 NOT NULL->NULLABLE、NULLABLE->NULLABLE、NOT NULL->NOT NULL。重要 如果 NULLABLE 情况下存在 NULL 的数据,将...
dla_table_2 CREATE EXTERNAL TABLE IF NOT EXISTS dla_table_2(customer_id bigint NOT NULL COMMENT '',order_id varchar NOT NULL COMMENT '',order_time date NOT NULL COMMENT '',order_amount double NOT NULL COMMENT '',order_type...
discount` decimal(15,2)NOT NULL,`l_tax` decimal(15,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_...
CREATE EXTERNAL TABLE IF NOT EXISTS dla_table_2(customer_id bigint NOT NULL COMMENT '',order_id varchar NOT NULL COMMENT '',order_time date NOT NULL COMMENT '',order_amount double NOT NULL COMMENT '',order_type ...
2)NOT NULL,`tax` decimal(10,2)NOT NULL,`shipping` decimal(10,2)NOT NULL,`total` decimal(10,2)NOT NULL,`address` varchar(200)NOT NULL,`city` varchar(100)NOT NULL,`state` varchar(50)NOT NULL,`country` varchar(50)NOT NULL,`...
CREATE EXTERNAL TABLE IF NOT EXISTS dla_table_1(id bigint NOT NULL COMMENT '',origin_state varchar NOT NULL COMMENT '',origin_zip varchar NOT NULL COMMENT '',destination_state varchar NOT NULL COMMENT '',destination_zip ...
在AnalyticDB for MySQL中创建数据库和表,用于存储OSS数据,请参见 CREATE DATABASE、CREATE TABLE。表结构信息如下所示。CREATE TABLE shipping(id bigint NOT NULL COMMENT '',origin_state varchar NOT NULL COMMENT '',origin_zip ...
在数据库tpch_100g中创建对应的表,方法如下: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_...
CREATE TABLE orders(O_ORDERKEY BIGINT NOT NULL PRIMARY KEY,O_CUSTKEY INT NOT NULL,O_ORDERSTATUS TEXT NOT NULL,O_TOTALPRICE DECIMAL(15,2)NOT NULL,O_ORDERDATE TIMESTAMPTZ NOT NULL,O_ORDERPRIORITY TEXT NOT NULL,O_CLERK TEXT ...
CREATE TABLE part(p_partkey BIGINT NOT NULL,p_name VARCHAR(55)NOT NULL,p_mfgr CHAR(25)NOT NULL,p_brand CHAR(10)NOT NULL,p_type VARCHAR(25)NOT NULL,p_size BIGINT NOT NULL,p_container CHAR(10)NOT NULL,p_retailprice DECIMAL...
在数据库tpch_100g中创建对应的表,方法如下: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_...
任务开始结束时间戳 `STATUS` varchar(128)NOT NULL DEFAULT '',-状态 `APPROXIMATE_ROWS` bigint(8)NOT NULL DEFAULT '0',-预估基线数据行数 `SCANNED_ROWS` bigint(8)NOT NULL DEFAULT '0',-已扫描行数,实际行数可大于预估行数 `AVG_...
CREATE TABLE customer(customer_id bigint NOT NULL COMMENT '顾客ID',customer_name varchar NOT NULL COMMENT '顾客姓名',phone_num bigint NOT NULL COMMENT '电话',city_name varchar NOT NULL COMMENT '所属城市',sex int NOT NULL ...
CREATE TABLE PART(P_PARTKEY INTEGER NOT NULL,P_NAME VARCHAR(55)NOT NULL,P_MFGR CHAR(25)NOT NULL,P_BRAND CHAR(10)NOT NULL,P_TYPE VARCHAR(25)NOT NULL,P_SIZE INTEGER NOT NULL,P_CONTAINER CHAR(10)NOT NULL,P_RETAILPRICE NUMERIC...
CREATE TABLE `r_t2`(`a` bigint(20)UNSIGNED NOT NULL,`b` bigint(20)UNSIGNED NOT NULL,`c` datetime NOT NULL,`d` varchar(16)NOT NULL,`e` varchar(16)NOT NULL)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 PARTITION BY RANGE(YEAR(`c`))...
V2.1版本起支持的建表语法:设置a列为distribution key,系统会对a列的值做hash操作,再取模,即hash(a)%shard_count=shard_id,结果相同的一组数据分布在同一个Shard内 CREATE TABLE tbl(a int NOT NULL,b text NOT NULL)WITH...
CREATE TABLE `r_t2`(`a` bigint(20)UNSIGNED NOT NULL,`b` bigint(20)UNSIGNED NOT NULL,`c` datetime NOT NULL,`d` varchar(16)NOT NULL,`e` varchar(16)NOT NULL)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 PARTITION BY RANGE(YEAR(`c`))...
`SUM_WAIT_TIME` bigint(21)unsigned NOT NULL DEFAULT '0',`MIN_WAIT_TIME` bigint(21)unsigned NOT NULL DEFAULT '0',`MAX_WAIT_TIME` bigint(21)unsigned NOT NULL DEFAULT '0',`SUM_EXEC_TIME` bigint(21)unsigned NOT NULL DEFAULT '0...
CREATE EXTERNAL TABLE shipping(id bigint NOT NULL COMMENT '',origin_state varchar NOT NULL COMMENT '',origin_zip varchar NOT NULL COMMENT '',destination_state varchar NOT NULL COMMENT '',destination_zip varchar NOT NULL ...
2)NOT NULL,l_tax DECIMAL(15,2)NOT NULL,l_returnflag CHAR(1)NOT NULL,l_linestatus CHAR(1)NOT NULL,l_shipdate DATE NOT NULL,l_commitdate DATE NOT NULL,l_receiptdate DATE NOT NULL,l_shipinstruct CHAR(25)NOT NULL,l_shipmode ...
示例 测试数据 表 1.T1 s(BIGINT NOT NULL)e(BIGINT NOT NULL)1 3-2 1 测试语句 CREATE TEMPORARY TABLE input_table(s BIGINT NOT NULL,e BIGINT NOT NULL)WITH('connector'='datagen');CREATE TEMPORARY TABLE output_table(s BIGINT NOT...
本文示例中,测试所用的ECS自建MySQL源库名为 test_adb,并在该库中创建了一张名为 goods 的源表,建表语句如下:CREATE TABLE goods(goods_id bigint(20)NOT NULL,price double NOT NULL,class bigint(20)NOT NULL,name varchar(32)NOT ...
CREATE EXTERNAL TABLE shipping(id bigint NOT NULL COMMENT '',origin_state varchar NOT NULL COMMENT '',origin_zip varchar NOT NULL COMMENT '',destination_state varchar NOT NULL COMMENT '',destination_zip varchar NOT NULL ...
体验内容 本次体验中用到的commerce_db数据库中有三张表:customer_info:用户基本信息表 product_info:产品基本信息表 order_info:订单基本信息表 其表结构如下:CREATE TABLE `customer_info`(`customer_id` bigint UNSIGNED NOT NULL ...
l_discount numeric(15,2)NOT NULL,l_tax numeric(15,2)NOT NULL,l_returnflag character(1)NOT NULL,l_linestatus character(1)NOT NULL,l_shipdate date NOT NULL,l_commitdate date NOT NULL,l_receiptdate date NOT NULL,l_...
本文示例中,测试所用的RDS MySQL源库名为 test_adb,并在该库中创建了一张名为 goods 的源表,建表语句如下:CREATE TABLE goods(goods_id bigint(20)NOT NULL,price double NOT NULL,class bigint(20)NOT NULL,name varchar(32)NOT NULL,...
例如某面向卖家的电商应用,需要对如下单表进行水平拆分:CREATE TABLE sample_order(id INT(11)NOT NULL,sellerId INT(11)NOT NULL,trade_id INT(11)NOT NULL,buyer_id INT(11)NOT NULL,buyer_nick VARCHAR(64)DEFAULT NULL,PRIMARY KEY...
`start` bigint(21)NOT NULL COMMENT 'start value',`increment` bigint(21)NOT NULL COMMENT 'increment value',`cache` bigint(21)NOT NULL COMMENT 'cache size',`cycle` bigint(21)NOT NULL COMMENT 'cycle state',`round` bigint(21)...
CREATE TABLE customer(customer_id bigint NOT NULL COMMENT '顾客ID',customer_name varchar NOT NULL COMMENT '顾客姓名',phone_num bigint NOT NULL COMMENT '电话',city_name varchar NOT NULL COMMENT '所属城市',sex int NOT NULL ...
CREATE TABLE orders(o_orderkey bigint NOT NULL COMMENT'',o_custkey int NOT NULL COMMENT'',o_orderstatus varchar NOT NULL COMMENT'',o_totalprice decimal(15,2)NOT NULL COMMENT'',o_orderdate date NOT NULL COMMENT'',o_...
s_city text NOT NULL,s_name text NOT NULL,s_address text NOT NULL,s_phone text NOT NULL,p_name text NOT NULL,p_mfgr text NOT NULL,p_category text NOT NULL,p_brand text NOT NULL,p_color text NOT NULL,p_type text NOT NULL,p_...
CREATE TABLE `r_t2`(`a` bigint(20)UNSIGNED NOT NULL,`b` bigint(20)UNSIGNED NOT NULL,`c` datetime NOT NULL,`d` varchar(16)NOT NULL,`e` varchar(16)NOT NULL)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 PARTITION BY RANGE(YEAR(`c`))...
SQL%sql CREATE TABLE events(id LONG NOT NULL,date STRING NOT NULL,location STRING,description STRING);ALTER TABLE events CHANGE COLUMN date DROP NOT NULL;您可以使用以下命令对添加到现有的Delta表进行约束。NOT NULLALTER TABLE...
`PROCS_CPU_RATIO` double NOT NULL DEFAULT '0',`PROCS_IOPS` double NOT NULL DEFAULT '0',`PROCS_IOPS_READ` double NOT NULL DEFAULT '0',`PROCS_IOPS_WRITE` double NOT NULL DEFAULT '0',`PROCS_IO_READ_BYTES` bigint NOT NULL ...
Oracle 记录锁表:CREATE TABLE dtx_row_lock(action_id varchar2(64)NOT NULL,tx_id varchar2(128)NOT NULL,table_name varchar2(64)DEFAULT NULL,row_key varchar2(250)PRIMARY KEY,instance_id varchar2(32)NOT NULL,context varchar2...
sent` int(11)NOT NULL,`rows_examined` int(11)NOT NULL,`db` varchar(512)NOT NULL,`last_insert_id` int(11)NOT NULL,`insert_id` int(11)NOT NULL,`server_id` int(10)unsigned NOT NULL,`sql_text` varchar(2000)NOT NULL,`thread_id`...
CREATE TABLE orders(orderkey BIGINT NOT NULL,custkey BIGINT NOT NULL,orderdate DATE NOT NULL)PARTITION BY RANGE COLUMNS(orderdate)(PARTITION p0 VALUES LESS THAN('2021-10-01'));ALTER TABLE orders SET INTERVAL(MONTH,1);...
支持 db_name.table_name 格式,区分不同数据库下相同名字的表。IF NOT EXISTS 判断 table_name 指定的表是否存在,若存在,则不执行建表语句。IGNORE 可选参数,若表中已有相同主键的记录,新记录不会被写入。REPLACE 可选参数,若表中已...