#! /bin/bash
#===============
#p_dm_stock_d.sh
#===============
DT=`date -d '-1 day' "+%Y-%m-%d"`
DT_1=`date -d '-2 day' "+%Y-%m-%d"`
if[$1];then
DT=$1
fi
SQL="
insert overwrite table dm_stock_d
select
t.date_d
,t.open
,t.high
,t.close
,a.close
,t.low
,t.volume
,a.volume
,t.price_change
,t.p_change
,t.ma5
,t.ma10
,t.ma20
,t.v_ma5
,t.v_ma10
,t.v_ma20
,t.turnover
,a.turnover
,t.STOCKCODE
from (select * from dw_stock_d where date_d='"${DT}"') t
left join (select * from dw_stock_d where date_d='"${DT_1}"') a
on t.stockcode = a.stockcode;
"
echo "${SQL}"
hive -e "${SQL}"
#===============
#p_dm_stock_d.sh
#===============
DT=`date -d '-1 day' "+%Y-%m-%d"`
DT_1=`date -d '-2 day' "+%Y-%m-%d"`
if[$1];then
DT=$1
fi
SQL="
insert overwrite table dm_stock_d
select
t.date_d
,t.open
,t.high
,t.close
,a.close
,t.low
,t.volume
,a.volume
,t.price_change
,t.p_change
,t.ma5
,t.ma10
,t.ma20
,t.v_ma5
,t.v_ma10
,t.v_ma20
,t.turnover
,a.turnover
,t.STOCKCODE
from (select * from dw_stock_d where date_d='"${DT}"') t
left join (select * from dw_stock_d where date_d='"${DT_1}"') a
on t.stockcode = a.stockcode;
"
echo "${SQL}"
hive -e "${SQL}"