mirror of
https://github.com/ivuorinen/cheatsheet-tldr.git
synced 2026-01-26 11:33:59 +00:00
31 lines
880 B
Plaintext
31 lines
880 B
Plaintext
---
|
|
syntax: markdown
|
|
tags: [tldr, common]
|
|
source: https://github.com/tldr-pages/tldr.git
|
|
---
|
|
# odpscmd table
|
|
|
|
> Create and modify tables in ODPS (Open Data Processing Service).
|
|
> See also: `odpscmd`.
|
|
> More information: <https://www.alibabacloud.com/help/en/maxcompute/user-guide/maxcompute-client>.
|
|
|
|
- [Interactive] Create a table with partition and lifecycle:
|
|
|
|
`create table {{table_name}} ({{col}} {{type}}) partitioned by ({{col}} {{type}}) lifecycle {{days}};`
|
|
|
|
- [Interactive] Create a table based on the definition of another table:
|
|
|
|
`create table {{table_name}} like {{another_table}};`
|
|
|
|
- [Interactive] Add partition to a table:
|
|
|
|
`alter table {{table_name}} add partition ({{partition_spec}});`
|
|
|
|
- [Interactive] Delete partition from a table:
|
|
|
|
`alter table {{table_name}} drop partition ({{partition_spec}});`
|
|
|
|
- [Interactive] Delete table:
|
|
|
|
`drop table {{table_name}};`
|