## ycsb 导入数据
root@XX.14.40.197


1、对portrait压测
ansible hadoop -i hosts_hbase_portrait_20230730.txt -m shell -a "hostname && chdir=/data/workspace/ycsb-0.17.0 nohup bin/ycsb load hbase20 -P workloads/workload_insert -cp /usr/local/fqlhadoop/hbase/conf -p table=usertable -p columnfamily=cf >> load_`date +'%Y%m%d_%H%M%S'`.log 2>&1 &"
ansible hadoop -i hosts_hbase_portrait_20230730.txt -m shell -a "hostname && /usr/java/default/bin/jps -l | grep Client | wc -l"
ansible hadoop -i hosts_hbase_portrait_20230730.txt -m shell -a "hostname && /usr/java/default/bin/jps -l | grep Client | awk '{print \$1}' | xargs kill -9" 
ansible hadoop -i hosts_hbase_portrait_20230730.txt -m shell -a "hostname && chdir=/data/workspace/ycsb-0.17.0 ls -lrt *202409*.log"


2、对portraitszl压测，部署ycsb
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m shell -a "hostname"

ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m copy -a "src=/data/datamanager/deploy/roles/hadoop/files/jdk1.8.0_171.tar.gz dest=/usr/java/"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "tar -zxvf /usr/java/jdk1.8.0_171.tar.gz -C /usr/java"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "rm -rf /usr/java/latest"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "chdir=/usr/java/ ln -s jdk1.8.0_171 latest"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m shell -a "sed -i 's#jdk1.7.0_79#default#' /etc/profile"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m shell -a "cat /etc/profile | grep JAVA_HOME"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "java -version"

ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m shell -a "mkdir -p /usr/local/fqlhadoop/"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m copy -a "src=/data/datamanager/deploy/roles/hbase/files/hbase-2.5.5.tar.gz dest=/usr/local/fqlhadoop/"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "chdir=/usr/local/fqlhadoop/ tar -zxvf hbase-2.5.5.tar.gz"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "chdir=/usr/local/fqlhadoop/ ln -s hbase-2.5.5 hbase"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "chdir=/usr/local/fqlhadoop/ ls -lrt"

ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m shell -a "mkdir -p /data/workspace/"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m copy -a "src=/data/datamanager/deploy/workspace/ycsb-0.17.0.tar.gz dest=/data/workspace/"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m command -a "chdir=/data/workspace/ tar -zxvf ycsb-0.17.0.tar.gz"
ansible hadoop -i hosts_hbase_ycsb_20241113.txt -m shell -a "hostname && chdir=/data/workspace/ycsb-0.17.0 nohup bin/ycsb load hbase20 -P workloads/workload_insert_query -cp /usr/local/fqlhadoop/hbase/conf -p table=usertable -p columnfamily=family >> load_`date +'%Y%m%d_%H%M%S'`.log 2>&1 &"

hbase建表语句
https://github.com/brianfrankcooper/YCSB/tree/master/hbase2