Example: Using FORCE to Change the Temperature of a Row Partition - Teradata Vantage - Analytics Database

Teradata Vantage™ - Teradata® Virtual Storage - 17.20

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
ulv1628112427040.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hkz1472253437334
Product Category
Teradata Vantage

The following example sets the temperature for a subset of rows a partitioned table. In this case, the rows are those in the combined partition identified by an external partition number of 9.

Ferret  ==>
> force "test.ppi_t02" 400 9 temperature = hot

FORCE command changed the temperature of table test.ppi_t02
to HOT for the specified partition.
The temperature of 5 cylinders have been changed to HOT.