CONTAINER=bdcsce
DIRECTORY=citibike
FILENAME=201612-citibike-tripdata

echo "Object Storage Container Name        :" $CONTAINER
echo "Data Set name (remove .zip or .csv)  :" $FILENAME
echo "-----------------------------------------------------------------"


# run hive
hive  <<EOF
DROP TABLE bike_trips_objectstore;

CREATE external TABLE bike_trips_objectstore ( 
TripDuration int,
StartTime timestamp,
StopTime timestamp,
StartStationID string,
StartStationName string,
StartStationLatitude string,
StartStationLongitude string,
EndStationID string,
EndStationName string,
EndStationLatitude string,
EndStationLongitude string,
BikeID int,
UserType string,
BirthYear int, 
Gender int
) 
ROW FORMAT delimited 
FIELDS TERMINATED BY ',' 
location 'swift://bdcsce.default/citibike/modified/';


SELECT count(*) FROM bike_trips_objectstore;

exit;

EOF