ST_StorageLocation - PolarDB - Alibaba Cloud Documentation Center

You can use this function to query the location of the Object Storage Service (OSS) file that stores the data of a trajectory object.

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)