Skip to content

Instantly share code, notes, and snippets.

View lapolonio's full-sized avatar
👨‍💻
probably learning something

Leonardo Apolonio lapolonio

👨‍💻
probably learning something
34 followers · 2 following
  • Washington DC
View GitHub Profile
@lapolonio
lapolonio / gist:bf1698d4c2f1a49b52f8bc5544f05fbe
Created November 28, 2017 02:21
tableau create date from number
DATEADD('second', INT([Pivot Field Values]), #1970-01-01#)
DATEADD('second', INT([windowstart]), #1970-01-01#)
DATEADD('second', INT([ts]), #1970-01-01#)
@lapolonio
lapolonio / gist:d46680f8241bce5baf87feaec5fa20a0
Created November 28, 2017 02:21
impala crete timestamp
unix_timestamp(starttime, 'yyyy-MM-dd HH:mm:ss')
@lapolonio
lapolonio / rsync
Created November 28, 2017 02:20
rsync -avz lapolonio@server:path/to/file.csv . --progress
@lapolonio
lapolonio / impala-shell with query output to file
Created November 28, 2017 02:20
impala-shell -i impala:25003 -B --output_delimiter=","\
-q "select * from database. table"\
--print_header -o ~/data/table.csv