System Grab Bag

View all TLDR pages from common (or from all pages)

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.