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}};
License and Disclaimer
The content on this page is copyright © 2014—present the tldr-pages team and contributors.This page is used with permission under Creative Commons Attribution 4.0 International License.
While we do attempt to make sure content is accurate, there isn't a warranty of any kind.