Anda dapat memanggil fungsi ini untuk mengatur pasangan AccessKey yang digunakan mengakses bucket Object Storage Service (OSS) tempat data objek trajectory disimpan.
Fungsi ini kemungkinan akan ditinggalkan (deprecated) pada versi mendatang. Gunakan untuk pengalaman yang lebih baik.
Sintaksis
trajectory ST_SetAccessKey(trajectory traj, text akid, text aksecret, bool checkvalid default true);Parameter
Parameter | Deskripsi |
traj | Objek trajectory. |
akid | ID AccessKey yang digunakan untuk mengakses bucket OSS. |
aksecret | Rahasia AccessKey yang digunakan untuk mengakses bucket OSS. |
checkvalid | Menentukan apakah akan memeriksa validitas pasangan AccessKey. Nilai default: |
Deskripsi
Fungsi ini mengatur ulang pasangan AccessKey yang digunakan untuk mengakses bucket OSS tempat data objek trajectory tertentu disimpan.
Saat membaca data trajectory dari file dalam bucket OSS, Anda harus memberikan pasangan AccessKey untuk mengakses bucket tersebut. Pasangan AccessKey terdiri dari ID AccessKey dan rahasia AccessKey, yang masing-masing berfungsi seperti username dan password.
Contoh
SELECT ST_SetAccessKey(traj, '<OSS_USER>', '<OSS_PWD>') FROM trajs;
st_setaccesskey
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"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)