#!/bin/bash
source /etc/profile
locate emg4051:/opt/software/hive/bin/hive
data=`date +%Y%m%d`
echo "启动hive ``````"
echo "创建临时表emg_tmpcxb ${data}"
hive -e "
drop table if exists emg_tmpcxb;
create table if not exists emg_tmpcxb(utc string)row format delimied fields
terminated by '\t' as select utc from emg.d181119 limit 5;
"
echo "建表成功 导入数据SUCCESS ${data}"
#!/bin/bash
HIVE_HOME=/opt/software/hive
echo "启动hive ``````"
echo "创建临时表emg_tmpcxb"
$HIVE_HOME/bin/hive -e "
drop table if exists emg.emg_tmpcxb;
create table if not exists emg.emg_tmpcxb(utc string)row format delimited fields
terminated by '\t';
"
echo "建表成功 开始导入数据"
$HIVE_HOME/bin/hive -e "
insert overwrite table emg.emg_tmpcxb select utc from emg.d181119 limit 5;
"
echo "数据导入成功"