AddComputedColumn
Adds a computed column to an Activated raw or time-range archive and backfills it. The column becomes visible atomically when the backfill completes. (AB#4189)
Examples
octo-cli -c AddComputedColumn -id <identifier> -n <name> -f <formula> -r <resultType>
Options
| Short | Long | Required | Description |
|---|---|---|---|
-id | --identifier | yes | Runtime id of the archive to add the computed column to |
-n | --name | yes | Output column name — the identifier formulas reference and the column appears under |
-f | --formula | yes | mXparser formula over other columns of the same row (e.g. 'activePower / apparentPower') |
-r | --resultType | yes | Declared result type the formula is cast back to: Boolean |
-x | --indexed | no | Whether to index the physical column ('true'/'false'). Defaults to true |