Nick Dietrich thedeetch

thedeetch / sessionize.sql

Created January 24, 2017 16:18

Hive Sessionization

	-- find session boundaries
	-- look at previous row timestamp, if more than 20 minutes ago, give that row a value of 1, else 0
	with session_start as (
	SELECT
	CASE
	WHEN timestamp - LAG(timestamp, 1, 0) OVER (PARTITION BY user_id, ORDER BY timestamp) > 1200000 -- 20 minutes
	THEN 1
	ELSE 0
	END as session_boundary,
	*

thedeetch / hotstrings.ahk

Created February 3, 2015 13:58

Hotstrings

	#SingleInstance force
	; SQL
	:*:ij`t::INNER JOIN `
	:*:loj`t::LEFT OUTER JOIN `
	:*:st`t::SHOW TABLES;
	:*:sct`t::SHOW CREATE TABLE `;{left 1}
	::scf`t::SELECT COUNT() FROM `;{left 1}
	::ssf`t::SELECT FROM `;{left 1}
	:*:ldata`t::LOAD DATA INPATH '' OVERWRITE INTO TABLE '';{left 2}
	:*:vddl`t::SELECT VIEW_DEFINITION FROM SYSIBM.VIEWS WHERE TABLE_SCHEMA = 'DB2' AND TABLE_NAME = ''{left 2}

thedeetch / yarn-cluster-prettyfier.user.js

Last active December 24, 2022 03:12

YARN Cluster Prettyfier

	// ==UserScript==
	// @name YARN Cluster Prettyfication
	// @namespace http://thedeetch.github.io
	// @version 0.5
	// @description Prettyfier for YARN cluster web UI
	// @author thedeetch
	// @match :///cluster*
	// @grant none
	// @require http://cdnjs.cloudflare.com/ajax/libs/moment.js/2.9.0/moment.js
	// ==/UserScript==

thedeetch / scrape-zoom.py

Last active August 29, 2015 14:13

Scrape Zoom Cable Modem Status Page

	import urllib, urllib2, cookielib
	from bs4 import BeautifulSoup
	import datetime
	from time import sleep
	import csv

	def main():
	login_url = "http://192.168.100.1/goform/login"
	status_url = "http://192.168.100.1/RgConnect.asp"

thedeetch / for.py

Last active August 29, 2015 14:12

Python large file read optimization