Returns the Object Storage Service (OSS) folder path where a trajectory object's .gtf file is stored.
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 to query. |
Description
If the trajectory object's data is stored in a .gtf file in OSS, ST_StorageLocation returns the path of the OSS folder that contains the file. If the trajectory object's data is not stored in OSS, the function returns null.
Example
SELECT ST_StorageLocation(traj) FROM trajs;Example 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)Each row in the result is an OSS URI identifying the folder that contains the trajectory's .gtf file. Rows that return null indicate trajectory objects whose data is not stored in OSS.
What's next
To work with cold data storage for trajectory objects in later versions, see Cold data tiered storage.