Sets the AccessKey secret on a trajectory object. The secret authenticates access to the Object Storage Service (OSS) bucket that stores the trajectory data.
Syntax
trajectory ST_SetAkSecret(trajectory traj, text aksecret, bool checkvalid default true);Parameters
| Parameter | Description |
|---|---|
traj | The trajectory object. |
aksecret | The AccessKey secret used to access the OSS bucket. |
checkvalid | Specifies whether to validate the AccessKey secret. Default value: true. If set to true, the system tests whether the AccessKey secret can access the OSS bucket. If the test fails, an error is returned. |
Description
When trajectory data is stored in an OSS bucket, an AccessKey pair is required to read the data. An AccessKey pair consists of an AccessKey ID and an AccessKey secret — the AccessKey ID identifies the account (similar to a username), and the AccessKey secret authenticates it (similar to a password). Use ST_SetAkSecret to set or update the AccessKey secret on an existing trajectory object.
Example
select ST_SetAkSecret(traj, '<OSS_PWD>') from trajs;
st_setaksecret
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sat Jan 01 03:15:42 2000","end_time":"Sat Jan 01 05:16:43 2000","spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47.244002354518 47.230026333034 0,64.978971942887 60.618813472986 0,77.621717839502 78.012496630661 0,80 78 0)","timeline":["Sat Jan 01 03:15:42 2000","Sat Jan 01 03:39:54 2000","Sat Jan 01 04:04:06 2000","Sat Jan 01 04:28:18 2000","Sat Jan 01 04:52:31 2000","Sat Jan 01 05:16:43 2000"]}}
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sat Jan 01 03:15:42 2000","end_time":"Sat Jan 01 05:16:43 2000","spatial":"LINESTRING(2 2 0,33.042158099636 36.832684322819 0,47.244002354518 47.230026333034 0,64.978971942887 60.618813472986 0,77.621717839502 78.012496630661 0,80 78 0)","timeline":["Sat Jan 01 03:15:42 2000","Sat Jan 01 03:39:54 2000","Sat Jan 01 04:04:06 2000","Sat Jan 01 04:28:18 2000","Sat Jan 01 04:52:31 2000","Sat Jan 01 05:16:43 2000"]}}
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sat Jan 01 03:15:42 2000","end_time":"Sat Jan 01 05:16:43 2000","spatial":"LINESTRING(2 2,33.042158099636 36.832684322819,47.244002354518 47.230026333034,64.978971942887 60.618813472986,77.621717839502 78.012496630661,80 78)","timeline":["Sat Jan 01 03:15:42 2000","Sat Jan 01 03:39:54 2000","Sat Jan 01 04:04:06 2000","Sat Jan 01 04:28:18 2000","Sat Jan 01 04:52:31 2000","Sat Jan 01 05:16:43 2000"]}}
TRAJECTORY EMPTY
(4 rows)