zhm1002的博客

1.准备测试数据 使用如下建表语句，并插入测试数据： CREATETABLEIFNOTEXISTS test_decimal( md5 string, id int, ty int, amount decimal(38, 12) ) stored as orc; insert into table test_decimal values ('9F99855A44BD41FE592B69E0D36BF3E8', 4591, 2, 18859...

以下脚本是对hive相关版本没有改变的 #!/bin/bash #set -x DB=$1 #获取hive表定义 ret=$(hive -e "use ${DB};show tables;"|grep -v _es|grep -v _hb|grep -v importinfo) ret=$(hive -e "use ${DB};show tables;"|grep -v _es|grep -v _hb|grep -v importinfo) for tem in $ret; do hive -