Greg Rahn gregrahn

Big into data long before data got big.™

gregrahn / 1-tpcds-query92.sql

Last active April 17, 2017 02:04

When switching from the legacy Oracle top-n syntax using rownum to the ANSI/ISO SQL:2008 fetch first syntax, the WinMagic SQL transformation is lost.

	-- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
	-- Using 1GB TPC-DS
	-- Table DDL: https://raw.githubusercontent.com/gregrahn/tpcds-kit/master/tools/tpcds.sql
	-- WinMagic paper: "WinMagic: subquery elimination using window aggregation"
	-- https://pdfs.semanticscholar.org/0bfa/e505ad588d00d4b204acf8ba4b5646eac244.pdf

	alter session set nls_date_format = 'YYYY-MM-DD';

	-- start query 1 in stream 0 using template query92.tpl

gregrahn / hms-queries.sql

Last active October 11, 2019 15:49

	--
	-- list db/table/num_rows for tables with stats
	--
	SELECT
	DBS.NAME AS DB_NAME,
	TBLS.TBL_NAME AS TABLE_NAME,
	TABLE_PARAMS.PARAM_VALUE as NUM_ROWS
	FROM DBS
	JOIN TBLS USING (DB_ID)
	JOIN TABLE_PARAMS USING (TBL_ID)

gregrahn / query_0.sql

Created May 16, 2019 04:11

	-- TPC-DS v2.11.0
	-- ./dsqgen -DIRECTORY ../query_templates -INPUT ../query_templates/templates.lst -VERBOSE Y -QUALIFY Y -SCALE 10000 -DIALECT netezza -OUTPUT_DIR /tmp

	-- start query 1 in stream 0 using template query1.tpl
	with customer_total_return as
	(select sr_customer_sk as ctr_customer_sk
	,sr_store_sk as ctr_store_sk
	,sum(SR_FEE) as ctr_total_return
	from store_returns
	,date_dim

gregrahn / pg-unpivot.sql

Last active August 1, 2019 04:57

	create table rj (l1 int, l2 int, l3 int);
	insert into rj values (0,0,0);
	insert into rj values (1,1,1);
	insert into rj values (1,0,1);
	insert into rj values (0,1,0);
	insert into rj values (1,0,0);

	select * from rj;

	l1 \| l2 \| l3

gregrahn / cloudera-impala-odbc.rb

Created December 12, 2019 22:34

	cask 'cloudera-impala-odbc' do
	version '2.6.8.1008'
	sha256 'dbc9a460004b93b39c1d9bfedf2c181226ee629e59c84774708ffd8fd4585a8d'

	url "https://downloads.cloudera.com/connectors/ClouderaImpala_ODBC_#{version}/macOS/ClouderaImpalaODBC.dmg"
	name 'Cloudera ODBC Driver for Impala'
	homepage 'https://www.cloudera.com/downloads'

	pkg 'ClouderaImpalaODBC.pkg'

gregrahn / qgen.py

Created December 15, 2019 08:11

	import time
	import sys
	import os

	cmd = "./dsqgen -QUIET Y -DIALECT netezza -SCALE 100000 -TEMPLATE crash.tpl -DIRECTORY ../query_templates"

	template1 = '''
	define C= ulist(random(1, {}, uniform),5);

	select

gregrahn / ui-protect-thumb-noenlarge.js

Last active February 4, 2025 16:04

Disable the thumbnail enlargement in UI Protect web UI

	// ==UserScript==
	// @name ui-protect-thumb-noenlarge
	// @namespace none
	// @version v0.1
	// @description Blocks JavaScript-based hover effects on thumbnails in Protect web UI
	// @author gregrahn
	// @match https://unifi.ui.com/consoles//protect/detections/find-anything
	// @include https:///protect/detections/find-anything
	// @grant none
	// ==/UserScript==