Data Lake Compute
- Getting Started
- Operation Guide
- Console Operation Introduction
- Data Development and Exploration
- Data Exploration
- Data Query Task
- Resource Management
- Engine Management
- SuperSQL Engine
- Standard Engine
- Resource Group
- Private Connection
- Storage Configuration
- Ops Management
- Insight Management
- System Management
- User and Permission Management
- Monitoring and Alarms
- Development Guide
- System Restraints
- Client Access
- JDBC Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Unified Statement
- DDL Statement
- ALTER TABLE
- DML Statement
- DQL Statement
- Iceberg Table Statement
- API Documentation
- Making API Requests
- Data Table APIs
- Task APIs
- Metadata APIs
- Service Configuration APIs
- Permission Management APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- General Reference
- Operation Guide on Connecting Third-Party Software to DLC
DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER TABLEALTER TABLE ... WRITE ORDERED BY
ALTER TABLE ... WRITE ORDERED BY
Last updated: 2024-08-07 17:18:07
Description
Supported engine: SparkSQL
Applicable table: External and native Iceberg tables
Purpose: Set the sorting method data insertion into a table.
Statement
ALTER TABLE table_identifierWRITE [LOCALLY] ORDERED BY{col_name [ASC|DESC] [NULLS FIRST|LAST]}[, ...]
Parameter
table_identifier: Data table nameExample
ALTER TABLE dempts WRITE ORDERED BY category, id;-- use optional ASC/DEC keyword to specify sort order of each field (default ASC)ALTER TABLE dempts WRITE ORDERED BY category ASC, id DESC;-- use optional NULLS FIRST/NULLS LAST keyword to specify null order of each field (default FIRST)ALTER TABLE dempts WRITE ORDERED BY category ASC NULLS LAST, id DESC NULLS FIRST;-- To order within each task, not across tasksALTER TABLE dempts WRITE LOCALLY ORDERED BY category, id;
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No