All Products
Search
Document Center

ApsaraDB RDS:ST_StorageLocation

Last Updated:Mar 28, 2026

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

Syntax

bool ST_StorageLocation(trajectory traj);

Parameters

ParameterDescription
trajThe 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)