1. 准备:
① 从官网下载jmeter binaries:
http://jmeter.apache.org/download_jmeter.cgi
②下载impala jdbc:
http://www.cloudera.com/content/www/en-us/downloads.html
2. 环境:
这里下载了apache-jmeter-2.13.tgz和Cloudera_ImpalaJDBC41_2.5.29.zip,集群环境是CDH-5.5(impala-2.3)
3. 执行:
a. 解压apache-jmeter-2.13.tgz,Cloudera_ImpalaJDBC41_2.5.29.zip。
拷贝Cloudera_ImpalaJDBC41_2.5.29下的jar到apache-jmeter-2.13/lib/ext:
b. 启动jmeter:
cd apache-jmeter-2.13/bin;
./jmeter.sh
c. 在执行计划中添加线程组。配置线程组运行参数Number of Threads(users)和
Loop Count。
d. 添加采样器:JDBC Request。配置variable name,并在Query框中添加sql语句。注意,variable name应该与下面JDBC configuration中的variable相同。
e. 添加JDBC配置:JDBC configuration。配置连接字符串和JDBC Driver.
Database URL: jdbc:impala://10.239.44.150:21050/tpcds_text_150;auth=noSasl
JDBC Driver class: com.cloudera.impala.jdbc41.Driver
f. 选择输出结果:监听器,这里选择了Aggregate Report /View Result In Table/View Result Tree。View Result In Table可以看到查询的返回结果及错误。Graph Results也可以添加进来用于观察throughput并做成图像。
g. 运行,点击
h. 结果查看:
View Results Tree:
Aggregate Report:
View Results in Table:
Graph Results: