1. 时间相关
echo `date -d "2018-10-10 +1 days" "+%Y-%m-%d %H:%M:%S"`
echo `date -d "" "+%Y-%m-%d %H:%M:%S"`
2. 远程连接mysql获取查询结果(一个字段)
#!/bin/bash
TEMP=$(mysql -hslave5 -uyangqi -pxiaoer -P3306 test1 --skip-column-names -e "select order_id from us_order;")
echo ${TEMP} [ > /home/yangqi/logs/mysql.log]
3. hive相关
3.1. 判断hive中的库是否存在
#!/bin/bash
DATABASE=databaseName
hive -e "desc database ${DATABASE};" 2>&1 | grep 'Database does not exist'
ISEXIST=$?
echo ${ISEXIST}
if [ ${ISEXIST} -ne 0 ];
then
echo The database ${DATABASE} already exist!
else
echo The database ${DATABASE} is not exist!
fi
3.2. 判断hive中的表是否存在
#!/bin/bash
DATABASE=databaseName
TABLE=tableName
hive -e "desc ${DATABASE}.${TABLE};" 2>&1 | grep 'Table not found'
ISEXIST=$?
echo ${ISEXIST}
if [ ${ISEXIST} -ne 0 ];
then
echo The table ${DATABASE}.${TABLE} already exist!
else
echo The table ${DATABASE}.${TABLE} is not exist!
fi
3.3. 删除hive中已经存在的数据库
#!/bin/bash
DATABASE=databaseName
hive -e "drop database ${DATABASE} cascade;"
5.4. 在hive中创建数据库
#!/bin/bash
DATABASE=databaseName
hive -e "create database if not exists ${DATABASE};"
5.5. 在hive中创建表
#!/bin/bash
DATABASE=databaseName
TABLE=tableName
hive -e "use ${DATABASE};
create table if not exists ${TABLE} (
order_id int,
order_no string,
order_date timestamp,
user_id int,
user_name string,
order_money double
)
partitioned by (year string, month string, day string)
row format delimited
fields terminated by '\t'
lines terminated by '\n'
stored as textfile;"