Get all STORED fields from a query

ikarius_2 · November 24, 2011, 12:04am

Hi all,

First, i'm a beginner with ES, so .. be kind (though i've a strong
background with Lucene).

I'm trying to get all the stored fields (with a mapping) in my seach.
These
stored fields seems to be stored alright, thic code:

   SearchResponse rsp = getClient().prepareSearch(INDEX_SKIMM)
           .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
           .setQuery(q)
           .addField("firstname")
           .setFrom(startIndex)
           .setSize(limit > MAX_RESULTS ? MAX_RESULTS : limit )
           .setExplain(true)
           .execute()
           .actionGet();

returns me the 'firstname' field in my SearchHit;

But, if i remove the
.addField("firstname")
line, i do not get ANY of my stored fields.

Is it normal ?

I've found a (ugly) workaround by adding this line in the search:
.addField("*")

and i gain access to all stored fields.

Thanks in advance for your answers !

kimchy · November 24, 2011, 1:52pm

I assume that when you don't specify any field, and you get nothing back,
is because you disabled the _source field. If you want ot get all the
stored fields, then yes, you need to do: addField("*"), why is this ugly?

Btw, most times, going each field specifically stored is wrong, and _source
should be used.

On Thu, Nov 24, 2011 at 2:04 AM, ikarius frederic.vergez@gmail.com wrote:

Hi all,

First, i'm a beginner with ES, so .. be kind (though i've a strong
background with Lucene).

I'm trying to get all the stored fields (with a mapping) in my seach.
These
stored fields seems to be stored alright, thic code:
  SearchResponse rsp = getClient().prepareSearch(INDEX_SKIMM)
          .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
          .setQuery(q)
          .addField("firstname")
          .setFrom(startIndex)
          .setSize(limit > MAX_RESULTS ? MAX_RESULTS : limit )
          .setExplain(true)
          .execute()
          .actionGet();
returns me the 'firstname' field in my SearchHit;

But, if i remove the
.addField("firstname")
line, i do not get ANY of my stored fields.

Is it normal ?

I've found a (ugly) workaround by adding this line in the search:
.addField("*")

and i gain access to all stored fields.

Thanks in advance for your answers !

ikarius_2 · November 24, 2011, 5:09pm

Thank you for your fast answer, will try _source ASAP !

On 24 nov, 14:52, Shay Banon kim...@gmail.com wrote:

I assume that when you don't specify any field, and you get nothing back,
is because you disabled the _source field. If you want ot get all the
stored fields, then yes, you need to do: addField("*"), why is this ugly?

Btw, most times, going each field specifically stored is wrong, and _source
should be used.

On Thu, Nov 24, 2011 at 2:04 AM, ikarius frederic.ver...@gmail.com wrote:

Hi all,

First, i'm a beginner with ES, so .. be kind (though i've a strong
background with Lucene).

I'm trying to get all the stored fields (with a mapping) in my seach.
These
stored fields seems to be stored alright, thic code:
  SearchResponse rsp = getClient().prepareSearch(INDEX_SKIMM)
          .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
          .setQuery(q)
          .addField("firstname")
          .setFrom(startIndex)
          .setSize(limit > MAX_RESULTS ? MAX_RESULTS : limit )
          .setExplain(true)
          .execute()
          .actionGet();
returns me the 'firstname' field in my SearchHit;

But, if i remove the
.addField("firstname")
line, i do not get ANY of my stored fields.

Is it normal ?

I've found a (ugly) workaround by adding this line in the search:
.addField("*")

and i gain access to all stored fields.

Thanks in advance for your answers !

ikarius_2 · November 24, 2011, 5:12pm

Well ugly was a bit too much. But is this option documented ?
I tried this "at random" and it worked.

On 24 nov, 14:52, Shay Banon kim...@gmail.com wrote:

I assume that when you don't specify any field, and you get nothing back,
is because you disabled the _source field. If you want ot get all the
stored fields, then yes, you need to do: addField("*"), why is this ugly?

Btw, most times, going each field specifically stored is wrong, and _source
should be used.

On Thu, Nov 24, 2011 at 2:04 AM, ikarius frederic.ver...@gmail.com wrote:

Hi all,

First, i'm a beginner with ES, so .. be kind (though i've a strong
background with Lucene).

I'm trying to get all the stored fields (with a mapping) in my seach.
These
stored fields seems to be stored alright, thic code:
  SearchResponse rsp = getClient().prepareSearch(INDEX_SKIMM)
          .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
          .setQuery(q)
          .addField("firstname")
          .setFrom(startIndex)
          .setSize(limit > MAX_RESULTS ? MAX_RESULTS : limit )
          .setExplain(true)
          .execute()
          .actionGet();
returns me the 'firstname' field in my SearchHit;

But, if i remove the
.addField("firstname")
line, i do not get ANY of my stored fields.

Is it normal ?

I've found a (ugly) workaround by adding this line in the search:
.addField("*")

and i gain access to all stored fields.

Thanks in advance for your answers !

kimchy · November 24, 2011, 6:23pm

Yea, its documented:
Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Thu, Nov 24, 2011 at 7:12 PM, ikarius frederic.vergez@gmail.com wrote:

Well ugly was a bit too much. But is this option documented ?
I tried this "at random" and it worked.

On 24 nov, 14:52, Shay Banon kim...@gmail.com wrote:
I assume that when you don't specify any field, and you get nothing back,
is because you disabled the _source field. If you want ot get all the
stored fields, then yes, you need to do: addField("*"), why is this ugly?

Btw, most times, going each field specifically stored is wrong, and
_source
should be used.

On Thu, Nov 24, 2011 at 2:04 AM, ikarius frederic.ver...@gmail.com
wrote:

Hi all,

First, i'm a beginner with ES, so .. be kind (though i've a strong
background with Lucene).

I'm trying to get all the stored fields (with a mapping) in my seach.
These
stored fields seems to be stored alright, thic code:
  SearchResponse rsp = getClient().prepareSearch(INDEX_SKIMM)
          .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
          .setQuery(q)
          .addField("firstname")
          .setFrom(startIndex)
          .setSize(limit > MAX_RESULTS ? MAX_RESULTS : limit )
          .setExplain(true)
          .execute()
          .actionGet();
returns me the 'firstname' field in my SearchHit;

But, if i remove the
.addField("firstname")
line, i do not get ANY of my stored fields.

Is it normal ?

I've found a (ugly) workaround by adding this line in the search:
.addField("*")

and i gain access to all stored fields.

Thanks in advance for your answers !

ikarius_2 · November 25, 2011, 9:42am

Missed it, sorry.
Thanks again

On 24 nov, 19:23, Shay Banon kim...@gmail.com wrote:

Yea, its documented:Elasticsearch Platform — Find real-time answers at scale | Elastic.

On Thu, Nov 24, 2011 at 7:12 PM, ikarius frederic.ver...@gmail.com wrote:

Well ugly was a bit too much. But is this option documented ?
I tried this "at random" and it worked.

On 24 nov, 14:52, Shay Banon kim...@gmail.com wrote:

I assume that when you don't specify any field, and you get nothing back,
is because you disabled the _source field. If you want ot get all the
stored fields, then yes, you need to do: addField("*"), why is this ugly?

Btw, most times, going each field specifically stored is wrong, and
_source
should be used.

On Thu, Nov 24, 2011 at 2:04 AM, ikarius frederic.ver...@gmail.com
wrote:

Hi all,

First, i'm a beginner with ES, so .. be kind (though i've a strong
background with Lucene).

I'm trying to get all the stored fields (with a mapping) in my seach.
These
stored fields seems to be stored alright, thic code:
  SearchResponse rsp = getClient().prepareSearch(INDEX_SKIMM)
          .setSearchType(SearchType.DFS_QUERY_THEN_FETCH)
          .setQuery(q)
          .addField("firstname")
          .setFrom(startIndex)
          .setSize(limit > MAX_RESULTS ? MAX_RESULTS : limit )
          .setExplain(true)
          .execute()
          .actionGet();
returns me the 'firstname' field in my SearchHit;

But, if i remove the
.addField("firstname")
line, i do not get ANY of my stored fields.

Is it normal ?

I've found a (ugly) workaround by adding this line in the search:
.addField("*")

and i gain access to all stored fields.

Thanks in advance for your answers !

mathursharp · September 9, 2013, 10:15am

Hi,

Even though i enabled _source during mapping, i am not getting results without .addField("*"),
I am also getting a score of 1 for all results.

Please help me out.

Topic		Replies	Views
Get all STORED fields from a query Elasticsearch	1	315	July 6, 2017
Stored Fields (by default)? Elasticsearch	6	451	July 6, 2017
How to retrieving all fields with Java client? Elasticsearch	7	3391	July 6, 2017
Unable to load all stored fields Elasticsearch	2	385	July 6, 2017
Getting all fields with setting "stored": "true" Elasticsearch	2	310	July 6, 2017

Get all *STORED* fields from a query

Related topics

Get all STORED fields from a query