#!/bin/bash # # # # # # # # # # # # # # # # # # # # # # # @file :create_table.sh # @author :liushuai # @revision:2017-03-14 20:09 # # # # # # # # # # # # # # # # # # # # # # source ../prd_env.sh LOG_TIME=$(date +%Y%m%d -d "-2 day $ScheduleTime") year=${LOG_TIME:0:4} month=${LOG_TIME:4:2} day=${LOG_TIME:6:2} rm *.txt hadoop fs -get s3://mob-emr-test/liushuai/prd/${year}/${month}/${day}/table/*.txt java -cp ../${JAR} mobvista.prd.datasource.table.CreateMAppTable ${LOG_TIME} if [ $? -ne 0 ];then exit 255 fi java -cp ../${JAR} mobvista.prd.datasource.table.CreateDspAppTable if [ $? -ne 0 ];then exit 255 fi hadoop fs -mkdir -p s3://mob-emr-test/liushuai/prd/${year}/${month}/${day}/table hadoop fs -rm s3://mob-emr-test/liushuai/prd/${year}/${month}/${day}/table/M系统指定app的国家性别年龄.xls hadoop fs -rm s3://mob-emr-test/liushuai/prd/${year}/${month}/${day}/table/DSP指定app的国家性别年龄.xls hadoop fs -put M系统指定app的国家性别年龄.xls s3://mob-emr-test/liushuai/prd/${year}/${month}/${day}/table hadoop fs -put DSP指定app的国家性别年龄.xls s3://mob-emr-test/liushuai/prd/${year}/${month}/${day}/table