runningjon / tpc-h Goto Github PK

If the Intranet machine server is not networked, the test cannot be performed。Intranet machines do not need to check for the latest version of the code

Modify the code at the end of the tpch.sh

for j in $(curl google.com 2>&1 | grep "Couldn't resolve host"); do
	internet_down="1"
done

if [ "$internet_down" -eq "0" ]; then
	yum_installs
	repo_init
	script_check
else
   echo "############################################################################"
   echo	"Couldn't resolve host,The local code is not checked for the latest version."
   echo "############################################################################"
   echo ""
fi

Hi

Can we please either update the documentation and/or add more verbosity to the script along the lines that this script will turn on PQO (and make it the default optimiser) in case it's switched off on a GP database cluster.

Currently, the script enables PQO at the start of the run but leaves it set as the default optimiser once it's done. PQO is not the default optimiser for previous versions of GP (Example - 4.3.10).

Ideally, it would be good that the script switches off the PQO at the end of the run in case it (the script) turned it (PQO) on at runtime.

The script is great and I used it to collect TPC-H benchmarks before we migrate to new GP environment! Thanks.

-Amanjeet