"dfs_query_then_fetch" search type returns Error

senthil_prabhu · June 14, 2011, 10:44am

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filter[textfield/metadata](filtered(fieldname:*)-

FilterCacheFilterWrapper(_type:textfield)))
+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)]]]; nested: }
{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filter[textfield/metadata](filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)))
+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)]]]; nested: }
{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filter[textfield/metadata](filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)))
+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)]]]; nested: }
{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filter[textfield/metadata](filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)))
+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)]]]; nested: }
{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filter[textfield/metadata](filtered(fieldname:)-
FilterCacheFilterWrapper(_type:textfield)))
+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)-
FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:
IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

senthil_prabhu · June 14, 2011, 12:13pm

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu senthils...@gmail.com wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

kimchy · June 14, 2011, 4:33pm

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

senthil_prabhu · June 15, 2011, 9:57am

Ok thank you shay....

On Jun 14, 9:33 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

senthil_prabhu · June 15, 2011, 12:10pm

It's not working in ES 16.2 also .....

I have created a gist example in the below link

gist.github.com

https://gist.github.com/anonymous/1026952

gistfile1.txt

1. curl -XPUT 'http://localhost:9200/dbtest123'

2. curl -XPUT 'http://localhost:9200/dbtest123/datatable/_mapping' -d '{"datatable" : { "properties" :  { "message" : {"type" : "string","store" : "yes"} ,"userid": { "type":"long" , "store":"yes" } } }'

3. curl -XPUT 'http://localhost:9200/dbtest123/datatable/1' -d '{"message" :"test", "userid":1}'
4. curl -XPUT 'http://localhost:9200/dbtest123/datatable/2' -d '{"message" : "test", "userid":2}'
5. curl -XPUT 'http://localhost:9200/dbtest123/datatable/3' -d '{"message" :"test", "userid":3 }' 

6. curl -XPUT 'http://localhost:9200/dbtest123/datachild/_mapping' -d '{"child" : { "_parent" : {"type" : "datatable" } }}'

This file has been truncated. show original

On Jun 15, 2:57 pm, senthil prabhu senthils...@gmail.com wrote:

Ok thank you shay....

On Jun 14, 9:33 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

senthil_prabhu · June 15, 2011, 12:20pm

Sorry ignore the above gist url.. Please consider this one..

gist.github.com

https://gist.github.com/anonymous/1026952

gistfile1.txt

1. curl -XPUT 'http://localhost:9200/dbtest123'

2. curl -XPUT 'http://localhost:9200/dbtest123/datatable/_mapping' -d '{"datatable" : { "properties" :  { "message" : {"type" : "string","store" : "yes"} ,"userid": { "type":"long" , "store":"yes" } } }'

3. curl -XPUT 'http://localhost:9200/dbtest123/datatable/1' -d '{"message" :"test", "userid":1}'
4. curl -XPUT 'http://localhost:9200/dbtest123/datatable/2' -d '{"message" : "test", "userid":2}'
5. curl -XPUT 'http://localhost:9200/dbtest123/datatable/3' -d '{"message" :"test", "userid":3 }' 

6. curl -XPUT 'http://localhost:9200/dbtest123/datachild/_mapping' -d '{"child" : { "_parent" : {"type" : "datatable" } }}'

This file has been truncated. show original

On Jun 15, 5:10 pm, senthil prabhu senthils...@gmail.com wrote:

It's not working in ES 16.2 also .....

I have created a gist example in the below link

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 2:57 pm, senthil prabhu senthils...@gmail.com wrote:

Ok thank you shay....

On Jun 14, 9:33 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

senthil_prabhu · June 17, 2011, 8:59am

We are waiting for your suggestion shay...

On Jun 15, 5:20 pm, senthil prabhu senthils...@gmail.com wrote:

Sorry ignore the above gist url.. Please consider this one..

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 5:10 pm, senthil prabhu senthils...@gmail.com wrote:

It's not working in ES 16.2 also .....

I have created a gist example in the below link

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 2:57 pm, senthil prabhu senthils...@gmail.com wrote:

Ok thank you shay....

On Jun 14, 9:33 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

kimchy · June 17, 2011, 9:02am

Yea, I still need to check this. For now, you can use query_then_fetch.

On Friday, June 17, 2011 at 11:59 AM, senthil prabhu wrote:

We are waiting for your suggestion shay...

On Jun 15, 5:20 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

Sorry ignore the above gist url.. Please consider this one..

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 5:10 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

It's not working in ES 16.2 also .....

I have created a gist example in the below link

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 2:57 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

Ok thank you shay....

On Jun 14, 9:33 pm, Shay Banon <shay.ba...@elasticsearch.com (http://elasticsearch.com)> wrote:

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

senthil_prabhu · June 20, 2011, 10:31am

For your information

Same exception raised for range query too.

{"has_child" :{"type" : "numericfield", "query" :{ "range" :
{ "fieldname" : { "from" : "1", "to" : "15","include_lower" :
true,"include_upper" : true,"boost" : 1.0 } } }} }

On Jun 17, 2:02 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Yea, I still need to check this. For now, you can use query_then_fetch.

On Friday, June 17, 2011 at 11:59 AM, senthil prabhu wrote:

We are waiting for your suggestion shay...

On Jun 15, 5:20 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

Sorry ignore the above gist url.. Please consider this one..

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 5:10 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

It's not working in ES 16.2 also .....

I have created a gist example in the below link

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 2:57 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

Ok thank you shay....

On Jun 14, 9:33 pm, Shay Banon <shay.ba...@elasticsearch.com (http://elasticsearch.com)> wrote:

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

senthil_prabhu · June 21, 2011, 12:58pm

Hi Shay...

Did you got any idea to solve this issue..... We are waiting for your
reply....

Thank you..

On Jun 20, 3:31 pm, senthil prabhu senthils...@gmail.com wrote:

For your information

Same exception raised for range query too.

{"has_child" :{"type" : "numericfield", "query" :{ "range" :
{ "fieldname" : { "from" : "1", "to" : "15","include_lower" :
true,"include_upper" : true,"boost" : 1.0 } } }} }

On Jun 17, 2:02 pm, Shay Banon shay.ba...@elasticsearch.com wrote:

Yea, I still need to check this. For now, you can use query_then_fetch.

On Friday, June 17, 2011 at 11:59 AM, senthil prabhu wrote:

We are waiting for your suggestion shay...

On Jun 15, 5:20 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

Sorry ignore the above gist url.. Please consider this one..

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 5:10 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

It's not working in ES 16.2 also .....

I have created a gist example in the below link

"dfs_query_then_fetch" search type returns Error · GitHub

On Jun 15, 2:57 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

Ok thank you shay....

On Jun 14, 9:33 pm, Shay Banon <shay.ba...@elasticsearch.com (http://elasticsearch.com)> wrote:

Can you move to use 0.16.2 and if there is still a problem, can you post a recreation?

On Tuesday, June 14, 2011 at 3:13 PM, senthil prabhu wrote:

I am using ES version 16.0

On Jun 14, 3:44 pm, senthil prabhu <senthils...@gmail.com (http://gmail.com)> wrote:

I have a parent database with parent type "testdata" and child type
"testfield". I am running the below query with search type
"dfs_query_then_fetch" means i am getting the below exception. If i
run with default search type, i am getting the result successfully.

curl -XGET 'http://localhost:9200/dbtest/testdata/_search?
search_type=dfs_query_then_fetch' -d '{"query" :{ "bool" :
{ "must_not" : [{ "has_child" : {"type" : "testfield", "query" :
{ "bool" : { "should" : [{ "query_string" : { "default_field" :
"fieldname","query" : "fieldname:*","default_operator" :
"OR","analyzer" : standard","allow_leading_wildcard" :
true,"lowercase_expanded_terms": true,"enable_position_increments" :
true,"fuzzy_prefix_length" : 0,"fuzzy_min_sim" : 0.5,"phrase_slop" :
0,"boost" : 1.0 } }] } }} }] } }, "from" : 0, "size" : 20, "explain" :
false}'

{"error":"ReduceSearchPhaseException[Failed to execute phase [fetch],
[reduce] ; shardFailures {[uAXwvLCWQPqiy9Nn1Psq_g][db555][0]:
QueryPhaseExecutionException[[db555][0]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][1]:
QueryPhaseExecutionException[[db555][1]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][2]:
QueryPhaseExecutionException[[db555][2]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][3]:
QueryPhaseExecutionException[[db555][3]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }

{[uAXwvLCWQPqiy9Nn1Psq_g][db555][4]:
QueryPhaseExecutionException[[db555][4]: query[-
ConstantScore(child_filtertextfield/metadata)

+ConstantScore(:)],from[0],size[20]: Query Failed [Failed to execute
child query [filtered(fieldname:*)->FilterCacheFilterWrapper(_type:textfield)]]]; nested: }]; nested:

IndexOutOfBoundsException[index (0) must be less than size (0)];
","status":500}

Can any one help me....

sandeep15mca · June 22, 2011, 8:27am

Sir!
please tell me how we can apply groupby query in elastic search
querystring.

                              Your Thankfully

                             Sandeep Kummar Tiwari

srrin · June 27, 2011, 2:25pm

Hi Shay,
Did you got any chance to look into this "ReduceSearchPhaseException" exception. We are waiting for your response. Is it possible to get a solution in the next build?

As per your suggestion to use "query_then_fetch", we are previously using this search type but the relevance is not accurate because of multiple shards. Using "dfs_query_then_fetch" solved the relevance issue but it is raising "ReduceSearchPhaseException". Kindly help us to move forward. Searching is the very most important functionality in our application.

Thanks
SRRIN