Use ST_StorageLocation to return the external storage location of a trajectory - PolarDB

Returns the external storage location of a trajectory.

Note

This function is expected to be deprecated in a later version. Use Cold data tiered storage for a better experience.

Syntax

bool ST_StorageLocation(trajectory traj);

Parameters

Parameter	Description
traj	The trajectory object.

Description

If the trajectory is stored externally, this function returns the folder where the .gtf file that stores the trajectory is located. Otherwise, it returns null.

Example

SELECT ST_StorageLocation(traj) FROM trajs;
                                                   st_storagelocation                                                   
------------------------------------------------------------------------------------------------------------------------
 OSS://$(OSS_USER):<AccessKeySecret>@$(OSS_ENDPOINT)/$(OSS_BUCKET)/$(OSS_E_EXPORT)1/
 OSS://$(OSS_USER):<AccessKeySecret>@$(OSS_ENDPOINT)/$(OSS_BUCKET)/$(OSS_E_EXPORT)2/
 OSS://$(OSS_USER):<AccessKeySecret>@$(OSS_ENDPOINT)/$(OSS_BUCKET)/$(OSS_E_EXPORT)2/
 
(4 rows)