Crossfiltering with a server

First version that turned out to be too complicated is at https://github.com/uwdata/big-crossfilter/tree/complex.

~/.local/bin/csvcut -t -c FlightDate,DepTime,DepDelay,ArrTime,ArrDelay,AirTime,Distance flights-3m.csv > flights-3m-clean.csv

COPY flights FROM '/Users/domoritz/Developer/UW/crossfilter/data/flights-3m.csv' WITH CSV HEADER;

Run: monetdbd start monet

Connect: mclient -u monetdb -d flights

COPY INTO flights from '/Users/domoritz/Developer/UW/crossfilter/data/flights-3m.csv' USING DELIMITERS ',','\n','\"' best effort;

CREATE TABLE flights (
    "FL_DATE" numeric,
    "DEP_TIME" numeric,
    "DEP_DELAY" numeric,
    "ARR_TIME" numeric,
    "ARR_DELAY" numeric,
    "AIR_TIME" numeric,
    "DISTANCE" numeric
);