Import trajectory data from OSS using ST_importFrom - PolarDB

Imports trajectory data from Object Storage Service (OSS) into the PolarDB database.

Note

This function is not supported in later versions. Use Cold data tiered storage instead.

Syntax

trajectory ST_importFrom(trajectory traj);

Parameter	Description
traj	The trajectory object.

ST_importFrom performs the reverse of ST_ExportTo. Its behavior depends on where the trajectory data is currently stored:

If the trajectory data is stored in a PolarDB database table, the function returns the trajectory data.
If the trajectory data is stored in an OSS file, the function imports the data into the PolarDB database.

The function does not modify the source OSS file.

Use ST_ImportFrom with an UPDATE statement to change the data storage location for trajectory data from OSS to the PolarDB database.

UPDATE trajs
SET traj = ST_ImportFrom(traj);