测试结果

sql 99 39 24 23 14多了“;”，删掉！

run_all_queries.sh

#!/bin/bash
database="tpc_ds"
impala_demo="bigdata04:21050"
currentPath="/var/local/DSGen-software-code-3.2.0rc1/"
#sqlFile=`ls ${cuttentPath}queries*`
#for item in ${sqlFile[@]};do
#       echo "impala-shell --database=${database} -i ${impala_demo} -f ${item} & > ${item}.log"
#done
for (( item=1; item<100; item++ ));do
        #echo "impala-shell --database=$database -f ${currentPath}queries/q${item}.sql"
        #(impala-shell --database=tpc_ds -f /var/local/DSGen-software-code-3.2.0rc1/queries/q71.sql) 2>&1 >> $1
        (impala-shell --database=$database -f ${currentPath}queries/q${item}.sql) 2>&1 >> ${currentPath}logs/q${item}_$1.log
done

sh tools/run_all_queries.sh >> logs/journal/01.log 01 &
sh tools/run_all_queries.sh >> logs/journal/02.log 02 &
sh tools/run_all_queries.sh >> logs/journal/03.log 03 &
sh tools/run_all_queries.sh >> logs/journal/04.log 04 &
sh tools/run_all_queries.sh >> logs/journal/05.log 05 &
sh tools/run_all_queries.sh >> logs/journal/06.log 06 &
sh tools/run_all_queries.sh >> logs/journal/07.log 07 &
sh tools/run_all_queries.sh >> logs/journal/08.log 08 &
sh tools/run_all_queries.sh >> logs/journal/09.log 09 &
sh tools/run_all_queries.sh >> logs/journal/10.log 10 &