# Question about JDBC river
**URL:** https://discuss.elastic.co/t/question-about-jdbc-river/9088
**Category:** Elasticsearch
**Created:** [September 21, 2012, 3:43am UTC](https://discuss.elastic.co/t/question-about-jdbc-river/9088 "2012-09-21T03:43:10Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Bruce\_2](https://discuss.elastic.co/u/Bruce_2)
#### Post date: [September 21, 2012, 3:43am UTC](https://discuss.elastic.co/t/question-about-jdbc-river/9088/1 "2012-09-21T03:43:10Z")
I am using JDBC river plugin for my elastic search engine.
I want to know how can I give different weightings on different fields of
my index.
say for example "select a, b, c, d from table"
I want to give a:10%, b:20%, c:30%, d:40% for my search.
How can I do it?
Thanks!
Bruce
--
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [September 21, 2012, 10:03am UTC](https://discuss.elastic.co/t/question-about-jdbc-river/9088/2 "2012-09-21T10:03:59Z")
Not sure I fully understand your concern.
IMHO, it's a matter of mapping not of JDBC river.
If you want to increase scoring for some fields (boosting fields), you have 2 choices :
- do it at index time and define a boost when setting your mapping [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types.html)
- do it at query time (i recommand this option) for example for a TermQuery [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/query-dsl/term-query.html)
HTH
--
David 😉
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
Le 21 sept. 2012 à 05:43, Bruce [bruce.kau@qipost.com](mailto:bruce.kau@qipost.com) a écrit :
> I am using JDBC river plugin for my Elasticsearch engine.
> I want to know how can I give different weightings on different fields of my index.
>
> say for example "select a, b, c, d from table"
> I want to give a:10%, b:20%, c:30%, d:40% for my search.
>
> How can I do it?
>
> ## Thanks! Bruce
--
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 3:12am UTC](https://discuss.elastic.co/t/question-about-jdbc-river/9088/3 "2017-07-06T03:12:01Z")