You can use this function to query the location of the Object Storage Service (OSS) file that stores the data of a trajectory object.
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 data of the specified trajectory object is stored in a .gtf file in OSS, this function returns the information of the folder that stores the file. Otherwise, this function 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)