odps table

Create and modify tables in ODPS (Open Data Processing Service). See also odps. More information: https://www.alibabacloud.com/help/doc-detail/27971.htm.

• Create a table with partition and lifecycle:

create table table_name (col type) partitioned by (col type) lifecycle days;

• Create a table based on the definition of another table:

create table table_name like another_table;

• Add partition to a table:

alter table table_name add partition (partition_spec);

• Delete partition from a table:

alter table table_name drop partition (partition_spec);

• Delete table:

drop table table_name;