"dfs_query_then_fetch" search type returns Error


(senthil prabhu) #1

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) #2

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


(Shay Banon) #3

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) #4

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) #5

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


(senthil prabhu) #6

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

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

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) #7

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

https://gist.github.com/1026952

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

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

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


(Shay Banon) #8

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

https://gist.github.com/1026952

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

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

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) #9

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

https://gist.github.com/1026952

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

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

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) #10

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

https://gist.github.com/1026952

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

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

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) #11

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

                              Your Thankfully

                             Sandeep Kummar Tiwari

(srrin) #12

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


(system) #13