Anda dapat memanggil fungsi ini untuk menetapkan sepasang AccessKey. Sepasang AccessKey digunakan untuk mengakses Bucket OSS dari Object Storage Service (OSS) yang menyimpan data objek trajektori.
Fungsi ini tidak didukung di versi berikutnya. Gunakan Penyimpanan bertingkat data dingin sebagai gantinya.
Sintaksis
trajectory ST_SetAccessKey(trajectory traj, text akid, text aksecret, bool checkvalid default true);Parameter
Parameter | Deskripsi |
traj | Objek trajektori. |
akid | ID AccessKey yang digunakan untuk mengakses Bucket OSS. |
aksecret | Rahasia AccessKey yang digunakan untuk mengakses Bucket OSS. |
checkvalid | Menentukan apakah akan memeriksa validitas sepasang AccessKey. Nilai default: |
Deskripsi
Fungsi ini menyetel ulang sepasang AccessKey. Sepasang AccessKey digunakan untuk mengakses Bucket OSS yang menyimpan data objek trajektori tertentu.
Untuk membaca data trajektori dari file di Bucket OSS, Anda harus memberikan informasi sepasang AccessKey untuk mengakses Bucket OSS. Sepasang AccessKey terdiri dari ID AccessKey dan Rahasia AccessKey. ID AccessKey berfungsi seperti nama pengguna, sedangkan Rahasia AccessKey berfungsi seperti kata sandi.
Contoh
SELECT ST_SetAccessKey(traj, '<OSS_USER>', '<OSS_PWD>') FROM trajs;
st_setaccesskey
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sab Jan 01 03:15:42 2000","end_time":"Sab 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":["Sab Jan 01 03:15:42 2000","Sab Jan 01 03:39:54 2000","Sab Jan 01 04:04:06 2000","Sab Jan 01 04:28:18 2000","Sab Jan 01 04:52:31 2000","Sab Jan 01 05:16:43 2000"]}}
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sab Jan 01 03:15:42 2000","end_time":"Sab 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":["Sab Jan 01 03:15:42 2000","Sab Jan 01 03:39:54 2000","Sab Jan 01 04:04:06 2000","Sab Jan 01 04:28:18 2000","Sab Jan 01 04:52:31 2000","Sab Jan 01 05:16:43 2000"]}}
{"trajectory":{"version":1,"type":"STPOINT","leafcount":6,"start_time":"Sab Jan 01 03:15:42 2000","end_time":"Sab 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":["Sab Jan 01 03:15:42 2000","Sab Jan 01 03:39:54 2000","Sab Jan 01 04:04:06 2000","Sab Jan 01 04:28:18 2000","Sab Jan 01 04:52:31 2000","Sab Jan 01 05:16:43 2000"]}}
TRAJECTORY EMPTY
(4 baris)