You can use this function to import the data of a trajectory object from Object Storage Service (OSS) to the PolarDB database that is used to store the trajectory data.
This function is not supported in later versions. Use Cold data tiered storage instead.
Syntax
trajectory ST_importFrom(trajectory traj);Parameters
Parameter | Description |
traj | The trajectory object. |
Description
This function performs operations that are the reverse of the operations performed by the ST_ExportTo function. If the data of the specified trajectory object is stored in a PolarDB database table, this function returns the trajectory data. If the trajectory data is stored in a file in OSS, this function imports the trajectory data into the PolarDB database that is used to store the trajectory data. You can use this function and the Update command to change the data storage location for the specified trajectory object from OSS to the PolarDB database that is used to store the trajectory data.
This function does not change the OSS file that stores the trajectory data.
Examples
UPDATE trajs
SET traj = ST_ImportFrom(traj);