简单的shell脚本 执行hive

#!/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 "数据导入成功"