ST_AKID-ApsaraDB RDS(RDS)-阿里云帮助中心

Returns the AccessKey ID used to access the Object Storage Service (OSS) bucket where a trajectory object's data is stored. Returns null if the trajectory data is not stored in OSS.

Syntax

text ST_AKID(trajectory traj)

Parameters

Parameter	Description
`traj`	The trajectory object.

Usage notes

Trajectory data stored externally requires an AccessKey pair to access the OSS bucket. An AccessKey pair consists of an AccessKey ID and an AccessKey secret — the AccessKey ID identifies the caller (similar to a username) and the AccessKey secret authenticates the request (similar to a password).

Examples

Query the AccessKey ID for each trajectory in the trajs table:

SELECT ST_AKID(traj) FROM trajs;

Expected output:

      st_akid
--------------------------
 $(OSS_USER)
 $(OSS_USER)
 $(OSS_USER)