#!/bin/bash
DB_HOST='192.168.0.00'
DB_PORT='3306'
DB_NAME=default
TBL_NAME=table
USERNAME='root'
PASSWORD='123456'
PARAMS='?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai'
HIVE_DB='default'
HIVE_TIR='ods'
HIVE_TBL=$HIVE_TIR'_'$TBL_NAME
echo $HIVE_TBL
#构建hive建表语句
abc=$(mysql -h${DB_HOST} -P${DB_PORT} -u${USERNAME} -p${PASSWORD} information_schema -e "
SET SESSION group_concat_max_len=102400;
SELECT
CONCAT('CREATE TABLE IF NOT EXISTS ',
'${HIVE_DB}',
'.',
'${HIVE_TBL}',
' (',
SUBSTRING(column_info, 1, LENGTH(column_info) - 0),
')',
' COMMENT ',
'\'',
TABLE_COMMENT,
'\'',
' ROW FO