All Products
Search
Document Center

PolarDB:ST_StorageLocation

Last Updated:Mar 28, 2026

Returns the Object Storage Service (OSS) folder path where a trajectory object's data file is stored.

Note

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

Syntax

bool ST_StorageLocation(trajectory traj);

Parameters

Parameter

Description

traj

The trajectory object.

Description

If the trajectory object's data is stored in a .gtf file in OSS, the function returns the folder path containing that file. Otherwise, it returns null.

Examples

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)