# Dremio jdbc on apache jmeter

**URL:** <https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698>\
**Category:** Dremio University\
**Created:** [December 7, 2020, 3:26am UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698 "2020-12-07T03:26:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![i9um0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/i9um0/32/2999_2.png) [@i9um0](https://community.dremio.com/u/i9um0)\
**Post date:** [December 7, 2020, 3:26am UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698/1 "2020-12-07T03:26:15Z")

</div>

Hello,

we experienced error below from jdbc dremio during load test using jmeter-5.2

VALIDATION ERROR: Column ‘f5’ not found in any table

SQL Query select f5  
startLine 1  
startColumn 8  
endLine 1  
endColumn 9

[Error Id: 3232be85-a85d-4389-a1d8-cac1f7218b03 on localhost:31010]

(org.apache.calcite.runtime.CalciteContextException) From line 1, column 8 to line 1, column 9: Column ‘f5’ not found in any table

we didn’t find any problem using jdbc dremio on dbeaver with those query. the query is quite simple just " select f5,count(\*) as total from “localhive.default”.XXX group by f5" . our dremio version is /data/apps/dremio-community-11.0.0-202011171636110752-16ab953d.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [December 7, 2020, 7:21am UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698/2 "2020-12-07T07:21:06Z")

</div>

@i9um0

Are you able to provide us with the job profile, also what datatype is f5 column in Hive?

> **[How To Share A Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)**
>
> Tutorial explaining how to share a query profile in Dremio.

Thanks  
Bali

---

<div class="post-metadata">

**Author:** ![i9um0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/i9um0/32/2999_2.png) [@i9um0](https://community.dremio.com/u/i9um0)\
**Post date:** [December 7, 2020, 8:59am UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698/3 "2020-12-07T08:59:03Z")

</div>

hi Bali, datatype of f5 column is string. I forgot to tell you that when i execute query "select count(_) from fda\_orc" without group by column the query r[8753870c-4f1f-449e-a6c8-eba0dde1ada9.zip](https://community.dremio.com/uploads/short-url/yMowvecXEfLpyfcKFWXoi6QlEx7.zip) (8.9 KB) un well through jdbc apache jmeter. Attached file is profile for select count(_)

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [December 8, 2020, 4:12am UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698/4 "2020-12-08T04:12:45Z")

</div>

@i9um0

Do not find an error in the profile uploaded, does table fda\_orc have a column called “f5”

Can you run a “select \* from localhive.“default”.fda\_orc” via Dremio and send us the profile?

Also send us the output of “describe formatted default.fda\_orc” from Hive or Beeline

---

<div class="post-metadata">

**Author:** ![i9um0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/i9um0/32/2999_2.png) [@i9um0](https://community.dremio.com/u/i9um0)\
**Post date:** [December 8, 2020, 5:31am UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698/5 "2020-12-08T05:31:26Z")

</div>

Hi Bali,

sorry I uploaded wrong job profile, here with the correct one,  
one we specified column within query it will be error, but result will be ok if we query using select \* or select count(\*)

[ee0c4f27-57c0-421f-bfaa-61e2aeb7a2bd.zip](https://community.dremio.com/uploads/short-url/iSkivu7FVErTCgWP9cKuS8APfw2.zip) (5.9 KB)

---

<div class="post-metadata">

**Author:** ![i9um0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/i9um0/32/2999_2.png) [@i9um0](https://community.dremio.com/u/i9um0)\
**Post date:** [December 8, 2020, 5:44am UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698/6 "2020-12-08T05:44:46Z")

</div>

Hi Bali ,

below is hive cli result;

hive\> describe fda\_orc;  
OK  
reccon string   
f1 string   
f2 string   
f3 string   
f4 string   
f5 string   
f6 string   
f7 string   
f8 string   
f9 string   
Time taken: 0.148 seconds, Fetched: 10 row(s)  
hive\>

ini attached file is profile from select \* from localhive.“default”.fda\_orc  
[9b61ad88-6c65-4664-92f3-0bafc632588e.zip](https://community.dremio.com/uploads/short-url/eRC3IRIZpUuWLCmYwwNCx392jkZ.zip) (12.4 KB)

---

<div class="post-metadata">

**Author:** ![i9um0](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/i9um0/32/2999_2.png) [@i9um0](https://community.dremio.com/u/i9um0)\
**Post date:** [December 8, 2020, 1:35pm UTC](https://community.dremio.com/t/dremio-jdbc-on-apache-jmeter/6698/7 "2020-12-08T13:35:58Z")

</div>

Hi Bali,

sorry for my mistake configure CSV set data config using delimiter with “,” The delimiter lead jmeter error when parse my SQL command. After modification dremio jdbc work well. thank’s for your help