Skip to content

Instantly share code, notes, and snippets.

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

Leonardo Apolonio lapolonio

👨‍💻
probably learning something
  • Washington DC
View GitHub Profile
impala-shell -i impala:25003 -B --output_delimiter=","\
-q "select * from database. table"\
--print_header -o ~/data/table.csv
rsync -avz lapolonio@server:path/to/file.csv . --progress
@lapolonio
lapolonio / gist:d46680f8241bce5baf87feaec5fa20a0
Created November 28, 2017 02:21
impala crete timestamp
unix_timestamp(starttime, 'yyyy-MM-dd HH:mm:ss')
@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#)
MAIN_JAR=`ls -1t /path/to/file-*[0-9]-SNAPSHOT.jar | head -1`
scp ${MAIN_JAR} lapolonio@server:lib/
yarn logs -applicationId application_1510850272434_0098
yarn application -kill application_1496071732413_1565
@lapolonio
lapolonio / README.md
Last active March 22, 2022 15:02
Mac Setup
  1. install spotify https://www.spotify.com/us/download/mac/
  2. install whatsapp https://www.whatsapp.com/download
  3. install authy https://authy.com/download/
  4. install slack https://slack.com/downloads/mac
  5. install postman https://www.postman.com/downloads/
  6. install sublime text https://www.sublimetext.com/3
    1. open sublime from command line https://ashleynolan.co.uk/blog/launching-sublime-from-the-terminal
  7. install docker https://www.docker.com/products/docker-desktop
  8. install vscode https://code.visualstudio.com/docs/setup/mac#_installation
  9. Open the Command Palette (⇧⌘P) and type 'shell command' to find the Shell Command: Install 'code' command in PATH command.
@lapolonio
lapolonio / tableflips.md
Last active January 24, 2018 16:17
Tableflips
Table Flip Cmd / Description Tableflip
/tableflip (╯°□°)╯︵ ┻━┻
/tableflip adorable [word] (づ。◕‿‿◕。)づ ︵ ┻━┻
/tableflip battle (╯°□°)╯︵ ┻━┻ ︵ ╯(°□° ╯)
/tableflip bear [word] ʕノ•ᴥ•ʔノ ︵ ┻━┻
/tableflip bomb ( ・_・)ノ⌒●~*
/tableflip bored [word] (ノ゜-゜)ノ ︵ ┻━┻
/tableflip buffet (╯°□°)╯︵ ┻━━━┻
/tableflip cry [word] (╯'□')╯︵ ┻━┻
@lapolonio
lapolonio / run.sh
Created February 27, 2018 20:28
Maven Awesomeness
# use installed jars with profiles for a specific module
mvn verify -P <profiles -rf :<module> -o
@lapolonio
lapolonio / Technical Interview Guidelines.md
Last active April 21, 2018 06:19
Technical Interview Guidelines