Skip to content

Instantly share code, notes, and snippets.

@paulcarey
paulcarey / splits.md
Last active August 29, 2015 14:16
The madness of Vim

Vim

Horizontal Split

Vanilla:

sp, ^W s, ^W S, ^W ^S
@paulcarey
paulcarey / window_funcs.sql
Last active July 11, 2016 23:13
Filtering out duplicates
scratch=# create table pairs (name varchar(5), value integer);
CREATE TABLE
scratch=# insert into pairs values ('a', 1);
INSERT 0 1
scratch=# insert into pairs values ('a', 1);
INSERT 0 1
scratch=# insert into pairs values ('a', 1);
INSERT 0 1
scratch=# insert into pairs values ('a', 11);
INSERT 0 1
var counter = 0
var rdd = sc.parallelize(data)
rdd.foreach(x => counter += x)
def f(s: String) = {
val xs = s.split("\n").map(_.split(","))
val ys = xs.transpose.map(_.map(_.length).max)
val zs = xs.map(_.zip(ys))
val ls = zs.map(_.map { case (x,y) => x.padTo(y, ' ') }.mkString(" "))
ls.mkString("\n")
}
val s = """aaa,b,cc
|a,bbbbb,c""".stripMargin
val xs = List(1, 2, 3)
xs.??? => List(4, 5, 6)
xs.??? => List(1, -1, 2, -2, 3, -3)