ricardobarroslourenco

-- Defines a continuous range
UPDATE yulie
SET grades_continuous = cast(grades AS FLOAT)
WHERE grades ~ '^-?[0-9]+\.?[0-9]*$'

UPDATE yulie
SET grades_continuous = (CASE   -- Values are the median of ranges
              WHEN grades = 'A' OR grades = 'a' THEN 95
              WHEN grades = 'B' OR grades = 'b' THEN 85
              WHEN grades = 'C' OR grades = 'c' THEN 75

ricardobarroslourenco

#!/bin/sh

#################################################################
### Instalation routine for Apache Spark in an Ubuntu Machine ###
### Spark 1.5.1 / Scala 2.11.1 / Java 8 / Maven 3.3.3         ###
### Modified Routine for ATLAS Install                        ###
### Ricardo B. Lourenco - RDCEP.org                           ###
################################################################# 

#Setup for folder destination (in this case, /mnt/atlas)