ST_StorageLocation-ApsaraDB RDS(RDS)-阿里云帮助中心

Queries the OSS folder path where the data of a trajectory object is stored.

Syntax

bool ST_StorageLocation(trajectory traj);

Parameters

Parameter	Description
`traj`	The trajectory object.

Description

Returns the folder path of the Object Storage Service (OSS) location where the trajectory object's data is stored as a .gtf file. Returns null if the trajectory object's data is not stored as a .gtf file in OSS.

Examples

SELECT ST_StorageLocation(traj) FROM trajs;

Output:

                                                   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)