Skip to content

Instantly share code, notes, and snippets.

View robinsu's full-sized avatar
🎯
Focusing

SU YUN YUN robinsu

🎯
Focusing
View GitHub Profile
function ven_recomd_reccall(jsonStr) {
alert('OK');
}
var recomdParam = {};
recomdParam.token = "xVtZLw5p4n";
recomdParam.rec_pos = "p";
recomdParam.rec_type = "ClickStream";
recomdParam.uid = "venraaspt.gtm";
recomdParam.device = "pc";
recomdParam.topk = 10;
LAST_CONTAINER_ID=$(docker ps -q -n 1)
echo $LAST_CONTAINER_ID
docker exec -it $LAST_CONTAINER_ID /bin/bash
## hive -e "select avg_score - std_score as Gbl from (select avg(score) as avg_score, std(score) as std_score from ${TDB}.cooc_i2i_filter)t1 " > Gbl.tsv
## hive -e "select avg_score + 2.1 * std_score as GUB from (select avg(score) as avg_score, std(score) as std_score from ${TDB}.cooc_i2i_filter)t1 " > GUB.tsv
bq_sql=$(cat <<EOF
select avg_score - std_score as Gbl ,
avg_score + 2.1 * std_score as GUB
from (
select AVG(score) as avg_score, STDDEV(score) as std_score
from gohappy_tmp.cooc_i2i_filter
) t1
EOF