"dfs_query_then_fetch" search type returns Error

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....

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....

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....

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....

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

I have created a gist example in the below link

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....

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

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....

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....

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....

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....

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....

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

                              Your Thankfully

                             Sandeep Kummar Tiwari

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