码基的博客

kimball建模实践

mysql同步sqoop通用脚本 #!/bin/bash # 要同步的表名 db.tbl table_name=$1 # 表所在数据库url host:port url=$2 #登录mysql的用户密码 username=$3 password=$4 # 同步昨天的数据 p_d=$(date -d "-1 days" +%Y-%m-%d) # 日志存放目录 log="/tmp/chVmibiSUcyaqvWY/$p_d" # 数据同步base目录 base="/batch_data_sync/

Sub createTable() Columns(1).ClearContents Dim tableCount As Integer Dim fieldCount As Integer Dim fields As String Dim eachFieldCount As Integer Dim dt As String Dim f A...