Import OSS Trajectory Data into PolarDB via ST_importFrom - PolarDB

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

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

Syntax

trajectory ST_importFrom(trajectory traj);

Parameter	Description
`traj`	The trajectory object.

ST_importFrom is the reverse of ST_ExportTo. It checks where the trajectory data is stored and acts accordingly:

If the data is already in a PolarDB database table, the function returns it as-is.
If the data is stored in an OSS file, the function imports it into PolarDB.

The function does not modify the source file in OSS.

To migrate trajectory data storage from OSS back to PolarDB, combine ST_importFrom with an UPDATE statement.

Move all trajectory data in the trajs table from OSS into PolarDB:

UPDATE trajs
SET traj = ST_ImportFrom(traj);