Gunakan fungsi ini untuk menetapkan Rahasia AccessKey, yang digunakan untuk mengakses Bucket OSS dari Object Storage Service (OSS) tempat data objek trajektori tertentu disimpan.
Fungsi ini tidak didukung di versi mendatang. Sebagai gantinya, gunakan Penyimpanan bertingkat data dingin.
Sintaksis
trajectory ST_SetAkSecret(trajectory traj, text aksecret, bool checkvalid default true);Parameter
Parameter | Deskripsi |
traj | Objek trajektori. |
aksecret | Rahasia AccessKey yang digunakan untuk mengakses Bucket OSS. |
checkvalid | Menentukan apakah akan memeriksa validitas Rahasia AccessKey. Nilai default: |
Deskripsi
Fungsi ini menyetel ulang Rahasia AccessKey, yang digunakan untuk mengakses Bucket OSS tempat data trajektori tertentu disimpan.
Untuk membaca data trajektori dari file di Bucket OSS, Anda harus menyediakan informasi pasangan AccessKey untuk mengakses Bucket OSS. Pasangan AccessKey terdiri dari ID AccessKey dan Rahasia AccessKey. ID AccessKey berfungsi seperti nama pengguna, sedangkan Rahasia AccessKey berfungsi seperti kata sandi.
Contoh
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)