Returns the AccessKey ID of an externally stored trajectory.
Note
This function is expected to be deprecated in a later version. Use Cold data tiered storage for a better experience.
Syntax
text ST_AKID(trajectory traj);
Parameters
Parameter name | Description |
traj | The trajectory object. |
Description
If the trajectory is stored externally, this function returns the AccessKey ID used to store the trajectory. Otherwise, it returns null.
To read a trajectory from OSS external storage, you must provide an AccessKey pair. Each AccessKey pair consists of an AccessKey ID and an AccessKey secret, which can be understood as a username and a password.
Example
SELECT ST_AKID(traj) FROM trajs;
st_akid
--------------------------
$(OSS_USER)
$(OSS_USER)
$(OSS_USER)