failue running query [1-4] throughput test

[林柏年]

Hi, Recently I run query [1-4] through LOAD_TEST POWER_TEST THROUGHPUT_TEST

the command looks like:./bin/bigBench    runBenchmark  -f 7 -s 2.

I also modify the steps & query to run in bigBench.properties :

workload=BENCHMARK_START,LOAD_TEST,POWER_TEST,THROUGHPUT_TEST_1,BENCHMARK_STOP,VALIDATE_POWER_TEST,VALIDATE_THROUGHPUT_TEST_1


power_test_0=1-4

and error occurs when running throughput test,

This is my  BigBenchResult.log

 Feb 25, 2017 3:47:35 AM io.bigdatabenchmark.v1.driver.BigBench run

INFO: BigBench benchmark: Start
Feb 25, 2017 3:47:35 AM io.bigdatabenchmark.v1.driver.BigBench runModule
INFO: BigBench phase 1: Load test                             (this might take a while...)
Feb 25, 2017 4:11:16 AM io.bigdatabenchmark.v1.driver.BigBench runModule
INFO: BigBench phase 1: Load test                             finished. Time:          0h:23m:41s:010ms
Feb 25, 2017 4:11:16 AM io.bigdatabenchmark.v1.driver.BigBench runQueries
INFO: BigBench phase 2: Power test                            Running queries on          1 stream(s)
Feb 25, 2017 4:11:16 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  1 ( 1/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q01_hive_power_test_0.log
Feb 25, 2017 4:13:16 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  1 ( 1/ 4) finished. Time:          0h:01m:59s:267ms
Feb 25, 2017 4:13:16 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  2 ( 2/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q02_hive_power_test_0.log
Feb 25, 2017 4:21:59 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  2 ( 2/ 4) finished. Time:          0h:08m:43s:287ms
Feb 25, 2017 4:21:59 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  3 ( 3/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q03_hive_power_test_0.log
Feb 25, 2017 4:28:08 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  3 ( 3/ 4) finished. Time:          0h:06m:08s:937ms
Feb 25, 2017 4:28:08 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  4 ( 4/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q04_hive_power_test_0.log
Feb 25, 2017 4:46:24 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 2: Power test                            stream          0, query  4 ( 4/ 4) finished. Time:          0h:18m:16s:251ms
Feb 25, 2017 4:46:24 AM io.bigdatabenchmark.v1.driver.BigBench runQueries
INFO: BigBench phase 2: Power test                            finished. Time:          0h:35m:07s:767ms
Feb 25, 2017 4:46:24 AM io.bigdatabenchmark.v1.driver.BigBench runQueries
INFO: BigBench phase 3: First throughput test run             Running queries on          2 stream(s)
Feb 25, 2017 4:46:24 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          1, query  4 ( 1/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q04_hive_throughput_test_1_1.log
Feb 25, 2017 4:46:24 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          0, query  2 ( 1/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q02_hive_throughput_test_1_0.log
Feb 25, 2017 5:05:57 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          0, query  2 ( 1/ 4) finished. Time:          0h:19m:32s:730ms
Feb 25, 2017 5:05:57 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          0, query  1 ( 2/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q01_hive_throughput_test_1_0.log
Feb 25, 2017 5:10:15 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          0, query  1 ( 2/ 4) finished. Time:          0h:04m:17s:747ms
Feb 25, 2017 5:10:15 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          0, query  4 ( 3/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q04_hive_throughput_test_1_0.log
Feb 25, 2017 5:23:40 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          1, query  4 ( 1/ 4) finished. Time:          0h:37m:15s:681ms
Feb 25, 2017 5:23:40 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          1, query  2 ( 2/ 4) log file: /root/big-bench/Big-Data-Benchmark-for-Big-Bench/logs/q02_hive_throughput_test_1_1.log
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench runCmd
INFO: Command: [bash, /root/big-bench/Big-Data-Benchmark-for-Big-Bench/bin/bigBench, runQuery, -q, 2, -p, throughput_test_1, -t, 1, -f, 7, -s, 2, -U]
got non-zero return value: 1
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          1, query  2 ( 2/ 4) failed. Time:          0h:02m:03s:422ms
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench runQueries
INFO: BigBench phase 3: First throughput test run             failed. Time:          0h:39m:19s:155ms
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench run
INFO: ==============
Benchmark run terminated
Reason: An error occured while running a command in phase THROUGHPUT_TEST_1
==============
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench computeResult
INFO:
************
Big Data
Benchmark
Result
v1.0
************
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench computeResult
INFO: T_LOAD = 1421.01
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench computeResult
INFO: T_LD = 0.1 * T_LOAD: 142.101
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench computeResult
INFO: T_PT = 1594.3754745346266
Feb 25, 2017 5:25:43 AM io.bigdatabenchmark.v1.driver.BigBench computeResult
INFO: NOK: Some required BigBench phases were skipped. No final result available.
Feb 25, 2017 5:25:44 AM io.bigdatabenchmark.v1.driver.BigBench runCmd
INFO: stdout read thread was interrupted
Feb 25, 2017 5:25:44 AM io.bigdatabenchmark.v1.driver.BigBench$QueryThread call
INFO: BigBench phase 3: First throughput test run             stream          0, query  4 ( 3/ 4) failed. Time:          0h:15m:28s:887ms

error occurs when running query 2 in stream 1

 I am really new to hadoop and don`t know where to start ,and my query2 throughput test file is in attached file.

thanks

Best regards,

Bo-Nian Lin