rename

Renames fields.

Command properties

Item	Description
Command type	Processing query
Required permission	None
License usage	N/A
Parallel execution	Supported
Distributed execution	Not supported

Syntax

rename FROM as TO [, FROM as TO ...]

Options

FROM: Original field name. Separate multiple pairs with commas (,).
TO: New field name.

Error codes

Parse errors

Error code	Message	Description
20800	Enter the source field.	The source field name is not specified
20801	Enter the target field.	The new field name is not specified
20802	Invalid syntax: `as` is expected at [token].	The `as` keyword is missing or in the wrong position

Description

The rename command moves the value of the original field to a field with the new name and removes the original field. Records where the original field does not exist are passed through unchanged.

Examples

Renaming a field

table duration=1h FW_ASA | rename src_ip as source

Renames the src_ip field to source.

Renaming multiple fields at once
```
table duration=1h FW_ASA | rename src_ip as source, dst_ip as destination
```
Renames src_ip to source and dst_ip to destination.