TPC-DS测试基准参考GitHub:https://github.com/pivotalguru/TPC-DS
#gpadmin用户下,用rz命令上传附件中Greenplum_TPC_DS.tar.gz包到/home/gpadmin/目录下并解压
echo "export MASTER_DATA_DIRECTORY=/data/master/gpseg-1
source /opt/test/gpdb_dist/greenplum_path.sh" >> ~/.bashrc (注意.bashrc 和.bash_profile的环境变量都要配置,保险起见)
cd /home/gpadmin/TPC-DS
#1st parameter means data scala in terms of Gigabytes, the second parameter means dont't output the explain info.
./rollout.sh 100 false (这里可以根据GitHub的说明自定义修改,进行不同数据量的测试)
#the result is in TPC-DS/log/detailed_report.csv, summary_report.csv
参考文档:http://blog.csdn.net/huxuanlai/article/details/59497745