Skip to content

Instantly share code, notes, and snippets.

View andykram's full-sized avatar

Andy Kramolisch andykram

298 followers · 8 following
View GitHub Profile
@andykram
andykram / example_loj.md
Last active August 29, 2015 13:56

Assuming:

  • table1 and table2 both have a date partition with a column name of d
  • table2 references table1 by the column t1_id
  • table1 and table2 are stored in HDFS as RCFile

The following correctly produces NULL (empty) values:

WITH
 t1 AS (SELECT t1.id FROM table1 t1 WHERE t1.d='2014-02-24'),
@andykram
andykram / presto_head_stacktrace
Created May 1, 2014 20:13
2014-05-01T19:20:46.239+0000 ERROR SplitRunner-8-78 com.facebook.presto.execution.TaskExecutor Error processing Split 20140501_192032_00002_disgk.1.0-0 (start = 1398972045653, wall = 580 ms, cpu = 0 ms, calls = 1)
java.lang.LinkageError: loader constraint violation: loader (instance of com/facebook/presto/server/PluginManager$SimpleChildFirstClassLoader) previously initiated loading for a different type with name "io/airlift/slice/Slice"
at java.lang.ClassLoader.defineClass1(Native Method) ~[na:1.7.0_12-ea]
at java.lang.ClassLoader.defineClass(ClassLoader.java:791) ~[na:1.7.0_12-ea]
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) ~[na:1.7.0_12-ea]
at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) ~[na:1.7.0_12-ea]
at java.net.URLClassLoader.access$100(URLClassLoader.java:71) ~[na:1.7.0_12-ea]
at java.net.URLClassLoader$1.run(URLClassLoader.java:361) ~[na:1.7.0_12-ea]
at java.net.URLClassLoader$1.run(URLClassLoader.java:355) ~[na:1.7.0_12-ea]
at java.security.Ac
@andykram
andykram / .gvimrc
Created December 25, 2009 19:05
" Font
set guifont=Monaco:h12.00
" No audible bell
set vb
" No toolbar
set guioptions-=T
" Use console dialogs
@andykram
andykram / gist:329866
Created March 11, 2010 23:53
# print SQL to STDOUT
if ENV.include?('RAILS_ENV') && !Object.const_defined?('RAILS_DEFAULT_LOGGER')
require 'logger'
RAILS_DEFAULT_LOGGER = Logger.new(STDOUT)
end
@andykram
andykram / .vimrc
Created May 21, 2012 20:00
Using rails.vim to make backboning with the asset pipeline easier
" Shortcuts for backbone.js via the asset pipeline
autocmd User Rails Rnavcommand bbmodel app/assets/javascripts/backbone/models -suffix=.js.coffee -glob=*
autocmd User Rails Rnavcommand bbhelper app/assets/javascripts/backbone/helpers -suffix=.js.coffee -glob=*
autocmd User Rails Rnavcommand bbmixin app/assets/javascripts/backbone/mixins -suffix=.js.coffee -glob=*
autocmd User Rails Rnavcommand bbrouter app/assets/javascripts/backbone/routers -suffix=.js.coffee -glob=*
autocmd User Rails Rnavcommand bbtemplate app/assets/javascripts/backbone/templates -suffix=.jst.hbs -glob=**/*
autocmd User Rails Rnavcommand bbview app/assets/javascripts/backbone/views -suffix=.js.coffee -glob=**/*
" Shortcuts for less.js via the asset pipeline
autocmd User Rails Rnavcommand less app/assets/stylesheets/less -suffix=.less -glob=**/*
@andykram
andykram / gti.rb
Created August 17, 2012 08:46
GTI Homebrew Recipe
require 'formula'
# Documentation: https://github.com/mxcl/homebrew/wiki/Formula-Cookbook
# PLEASE REMOVE ALL GENERATED COMMENTS BEFORE SUBMITTING YOUR PULL REQUEST!
class Gti < Formula
homepage 'http://r-wos.org/hacks/gti'
url 'https://github.com/rwos/gti/tarball/master'
sha1 'f34d37ba4345b3b97eaa64280e6f60a6881c38d8'
version "0.1"
@andykram
andykram / STDOUT
Created January 25, 2013 02:02
Building mesos
===========================================================
Setting up build environment for x86_64 darwin12.2.1
===========================================================
checking whether we are using the GNU C++ compiler... (cached) yes
checking whether g++ accepts -g... (cached) yes
checking dependency style of g++... (cached) gcc3
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ISO C89... (cached) none needed
checking dependency style of gcc... (cached) gcc3
@andykram
andykram / perf.md
Created May 19, 2023 19:10
perf

‎‎​