Skip to content

Instantly share code, notes, and snippets.

@bsmedberg
bsmedberg / saveonerecord.pig
Created August 9, 2012 18:56
pig problem, can I do scalar assignments?
REGISTER 'socorro-toolbox-0.1-SNAPSHOT.jar'
REGISTER 'lib/akela-0.4-SNAPSHOT.jar'
SET pig.logfile saveonerecord.log;
SET default_parallel 2;
SET pig.tmpfilecompression true;
SET pig.tmpfilecompression.codec lzo;
uuid = '$uuid';
date = SUBSTRING(uuid, 30, 36);
@bsmedberg
bsmedberg / improveskiplist.pig
Created August 10, 2012 18:04
How do I use INDEXOF to filter in pig?
REGISTER 'socorro-toolbox-0.1-SNAPSHOT.jar'
REGISTER 'lib/akela-0.4-SNAPSHOT.jar'
SET pig.logfile improveskiplist.log;
SET default_parallel 2;
SET pig.tmpfilecompression true;
SET pig.tmpfilecompression.codec lzo;
DEFINE JsonMap com.mozilla.pig.eval.json.JsonMap();
DEFINE LookupFirstSourceFrame com.mozilla.socorro.pig.eval.LookupFirstSourceFrame();
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@bsmedberg
bsmedberg / gist:9f7cdc6e51034f0bc31c
Created September 11, 2015 14:32
Something wrong with get_pings or properties
pings = get_pings(sc, app="Firefox", channel=["nightly", "aurora", "beta"], , fraction=0.05)
props = get_pings_properties(pings, ["environment/build/xpcomabi",
"environment/build/version",
"environment/build/buildId",
"environment/settings/update/channel",
"environment/settings/e10sEnabled",
"payload/info/subsessionStartDate",
"payload/info/subsessionLength",
"payload/keyedHistograms/SUBPROCESS_ABNORMAL_ABORT"])
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@bsmedberg
bsmedberg / executed-query.txt
Created November 18, 2015 18:22
Redshift Rollup active-users
SELECT
buildversion,
buildid,
buildarchitecture,
channel,
os,
osversion,
osservicepackmajor,
osservicepackminor,
locale,
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@bsmedberg
bsmedberg / rollup.py
Created December 23, 2015 18:42
Summary queries for crash dashboard. See bug 1213417 and bug 1213423 for the derived stream schema
import psycopg2
import os
import sys
import csv
from datetime import datetime, date, timedelta
from utils import S3CompressedWriter
from summarize import summarize
# How many days "back" do we look for activity?
latency_interval = 10
@bsmedberg
bsmedberg / addon-distribution.ipynb
Created February 12, 2016 14:22
addon-distribution .take(20) issue
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.