Random bits of info

Had to work with some data that was one column of data in a fixed width format. Solution was to create an external table that was one column then use substr function to pull out the data. External table: CREATE EXTERNAL TABLE trmtmp_ext_table (     col1 text ) LOCATION (         'gpfdist://host-1:port/path/trmtmp.out',         'gpfdist://host-2:port/path/trmtmp.out',         'gpfdist://host-3:port/path/trmtmp.out' ) FORMAT 'text' LOG ERRORS INTO trmtmp_err_ext_table SEGMENT REJECT LIMIT 5 ROWS; View of the external table: DROP VIEW trmtmp_view_ext_tbl; CREATE VIEW trmtmp_view_ext_tbl AS ( SELECT     substr(col1,1,2) AS col1,     substr(col1,3,5) AS col2 FROM       trmtmp_ext_table ); Extrapolate from there.

A simple backup script for backing up my laptop. I have an OS X and Linux laptop so I wanted one script to put on both of them: #!/usr/bin/env homedir="$(echo $HOME)" dom=$(date +%d) ################### # START CONFIGURATION ################### # On the 15th of the month run an rsync --delete to clean out old file. Otherwise just run a regular rsync. if [ ${dom} -eq 15 ]; then   rsynccmnd="rsync --delete -avhz --stats --progress" else   rsynccmnd="rsync -avhz --stats --progress"fi # Path to the exclude file host=$(uname -a|cut -d ' ' -f 1) if [ "${host}" = "Darwin" ]; then  # OS X  excludefile="path to exclude file for OS X"  #EXAMPLE  # excludefile="${homedir}/Documents/Backup/backuplaptop_exclude_osx.txt" else  # Linux  #excludefile="path to exclude file for Linux"  #EXAMPLE  # excludefile="${homedir}/Documents/Backup/backuplaptop_exclude_linux.txt" fi # ...