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