#!/bin/bash
source ./common/tools.sh
today=${ScheduleTime:-$1}
echo "ScheduleTime=$ScheduleTime"
echo "toady=$today"
date_path=$(date +%Y/%m/%d -d "-1 day $today")
date_str_undline=$(date +%Y_%m_%d -d "-1 day $today")
date_str_midline=$(date +%Y-%m-%d -d "-1 day $today")
HIVE_CMD=$(hive_func)
hadoop fs -test -e s3://mob-emr-test/dataplatform/emr/event_export/event_export_${date_str_undline}
if [ $? -ne 0 ]; then
hadoop fs -mkdir -p s3://mob-emr-test/dataplatform/emr/event_export/event_export_${date_str_undline}
fi
$HIVE_CMD -v -hivevar prefix=$date_path -hivevar date_str_undline=$date_str_undline -hivevar date_str_midline=$date_str_midline -f progression_session.sql