MySQL 8.0からはウィンドウ関数が使えます。動作確認してないけどたぶんこういう感じで書けるはず:
SELECT
t1.accum_date
, t1.count
, SUM(t1.count) OVER (ORDER BY t1.accum_date) AS accum
FROM (
#!/bin/bash | |
GROUP=$(id -ng) | |
MYDIR=/lustre/${GROUP}/$USER | |
export HOME=$MYDIR | |
. /etc/profile.d/modules.sh | |
module load cuda9/9.1.85 | |
module load anaconda3/4.3.0 |
$ gcloud iam service-accounts create callee
$ gcloud iam service-accounts create caller
$ gcloud builds submit -t gcr.io/${PROJECT_ID}/oidctest .
$ gcloud beta run deploy --image=gcr.io/${PROJECT_ID}/oidctest --allow-unauthenticated \
--service-account=caller@${PROJECT_ID}.iam.gserviceaccount.com caller
$ gcloud beta run deploy --image=gcr.io/${PROJECT_ID}/oidctest --no-allow-unauthenticated \
--service-account=callee@{PROJECT_ID}.iam.gserviceaccount.com callee