Get DDL Statement Action
Get DDL Statement Action
Requestβ
GET /api/_get_ddl
Descriptionβ
Used to get the table creation statement, partition creation statement and rollup statement of the specified table.
Path parametersβ
None
Query parametersβ
db
Specify database
table
Specify table
Request bodyβ
None
Responseβ
{
"msg": "OK",
"code": 0,
"data": {
"create_partition": ["ALTER TABLE `tbl1` ADD PARTITION ..."],
"create_table": ["CREATE TABLE `tbl1` ...],
"create_rollup": ["ALTER TABLE `tbl1` ADD ROLLUP ..."]
},
"count": 0
}
Examplesβ
Get the DDL statement of the specified table
GET GET /api/_get_ddl?db=db1&table=tbl1
Response
{
"msg": "OK",
"code": 0,
"data": {
"create_partition": [],
"create_table": ["CREATE TABLE `tbl1` (\n `k1` int(11) NULL COMMENT \"\",\n `k2` int(11) NULL COMMENT \"\"\n) ENGINE=OLAP\nDUPLICATE KEY(`k1`, `k2`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`k1`) BUCKETS 1\nPROPERTIES (\n\"replication_num\" = \"1\",\n\"version_info\" = \"1,0\",\n\"in_memory\" = \"false\",\n\"storage_format\" = \"DEFAULT\"\n);"],
"create_rollup": []
},
"count": 0
}