# Scripting exception
**URL:** https://discuss.elastic.co/t/scripting-exception/3496
**Category:** Elasticsearch
**Created:** [November 1, 2010, 8:09am UTC](https://discuss.elastic.co/t/scripting-exception/3496 "2010-11-01T08:09:38Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@yingsun\_cheng](https://discuss.elastic.co/u/yingsun_cheng)
#### Post date: [November 1, 2010, 8:09am UTC](https://discuss.elastic.co/t/scripting-exception/3496/1 "2010-11-01T08:09:38Z")
Hi,
Can anybody help me? When I'm using "script" in my search query,
there are some excetions happens:
========== Request ===============
curl -XGET '[http://localhost:9200/twitter/user/\_search](http://localhost:9200/twitter/user/_search)?
pretty=true' -d '
{
"query" : {
"filtered" : {
"query" : {
"match\_all": {}
},
"filter" : {
"script" : {
"script" : "doc['age'].value \> 20"
}
}
}
}
}'
=========== Response ===============
{
"\_shards" : {
"total" : 5,
"successful" : 3,
"failed" : 2,
"failures" : [ {
"index" : "twitter",
"shard" : 4,
"reason" : "QueryPhaseExecutionException[[twitter][4]:
query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAllDocsFilter@aecd51))-
> ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> [Failed to execute main query]]; nested: CompileException[[Error: No
> field found for
> [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]]
> \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> nested: ElasticSearchIllegalArgumentException[No field found for
> [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]];
> "
> }, {
> "index" : "twitter",
> "shard" : 2,
> "reason" : "QueryPhaseExecutionException[[twitter][2]:
> query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAllDocsFilter@aecd51))-
> ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> [Failed to execute main query]]; nested: CompileException[[Error: No
> field found for
> [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]]
> \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> nested: ElasticSearchIllegalArgumentException[No field found for
> [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]];
> "
> } ]
> },
> "hits" : {
> "total" : 0,
> "max\_score" : null,
> "hits" :
> }
> }
> =========== Type Mapping ===================
> {
> "user": {
> "properties": {
> "name": {
> "type": "string",
> "index": "not\_analyzed"
> },
> "passwd": {
> "type": "string",
> "index": "no"
> },
> "sex": {
> "type": "boolean",
> "index": "yes",
> "null\_value" : "no"
> },
> "age": {
> "type": "integer",
> "index": "yes",
> "null\_value" : 0
> },
> "email": {
> "type": "string"
> },
> "address": {
> "type": "string"
> }
> }
> }
> }
---
### Author:  [@kimchy](https://discuss.elastic.co/u/kimchy)
#### Post date: [November 1, 2010, 1:11pm UTC](https://discuss.elastic.co/t/scripting-exception/3496/2 "2010-11-01T13:11:11Z")
Can you gist a curl recreation with setting up the data (and mappings)?
On Mon, Nov 1, 2010 at 10:09 AM, yingsun cheng [xingrongcheng@gmail.com](mailto:xingrongcheng@gmail.com)wrote:
> Hi,
> Can anybody help me? When I'm using "script" in my search query,
> there are some excetions happens:
> ========== Request ===============
> curl -XGET '[http://localhost:9200/twitter/user/\_search](http://localhost:9200/twitter/user/_search)?
> pretty=true' -d '
> {
> "query" : {
> "filtered" : {
> "query" : {
> "match\_all": {}
> },
> "filter" : {
> "script" : {
> "script" : "doc['age'].value \> 20"
> }
> }
> }
> }
> }'
> =========== Response ===============
> {
> "\_shards" : {
> "total" : 5,
> "successful" : 3,
> "failed" : 2,
> "failures" : [ {
> "index" : "twitter",
> "shard" : 4,
> "reason" : "QueryPhaseExecutionException[[twitter][4]:
>
> query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAllDocsFilter@aecd51
> ))-
>
> > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > [Failed to execute main query]]; nested: CompileException[[Error: No
> > field found for
> > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]]
> > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > nested: ElasticSearchIllegalArgumentException[No field found for
> > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]];
> > "
> > }, {
> > "index" : "twitter",
> > "shard" : 2,
> > "reason" : "QueryPhaseExecutionException[[twitter][2]:
>
> query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAllDocsFilter@aecd51
> ))-
>
> > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > [Failed to execute main query]]; nested: CompileException[[Error: No
> > field found for
> > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]]
> > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > nested: ElasticSearchIllegalArgumentException[No field found for
> > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]];
> > "
> > } ]
> > },
> > "hits" : {
> > "total" : 0,
> > "max\_score" : null,
> > "hits" :
> > }
> > }
> > =========== Type Mapping ===================
> > {
> > "user": {
> > "properties": {
> > "name": {
> > "type": "string",
> > "index": "not\_analyzed"
> > },
> > "passwd": {
> > "type": "string",
> > "index": "no"
> > },
> > "sex": {
> > "type": "boolean",
> > "index": "yes",
> > "null\_value" : "no"
> > },
> > "age": {
> > "type": "integer",
> > "index": "yes",
> > "null\_value" : 0
> > },
> > "email": {
> > "type": "string"
> > },
> > "address": {
> > "type": "string"
> > }
> > }
> > }
> > }
---
### Author:  [@yingsun\_cheng](https://discuss.elastic.co/u/yingsun_cheng)
#### Post date: [November 2, 2010, 1:49am UTC](https://discuss.elastic.co/t/scripting-exception/3496/3 "2010-11-02T01:49:28Z")
// Using elasticsearch-0.12.1
// Creat Index:
curl -XPUT '[http://localhost:9200/twitter/](http://localhost:9200/twitter/)'
// Put Mapping
curl -XPUT '[http://localhost:9200/twitter/user/\_mapping](http://localhost:9200/twitter/user/_mapping)' -d '
{
"user": {
"properties": {
"name": {
"type": "string",
"index": "not\_analyzed"
},
"age": {
"type": "integer",
"null\_value" : 0
}
}
}
}'
// Index
curl -XPOST '[http://localhost:9200/twitter/user/](http://localhost:9200/twitter/user/)' -d '
{
"name": "amdin",
"age": 25
}'
// Search with Script
curl -XGET '[http://localhost:9200/twitter/user/\_search?pretty=true](http://localhost:9200/twitter/user/_search?pretty=true)' -d
'
{
"query": {
"filtered": {
"query": {
"match\_all": {}
},
"filter": {
"script": {
"script": "doc['age'].value \> 25"
}
}
}
}
}'
// Then get Excetion
.....
On 11月1日, 下午9时11分, Shay Banon [shay.ba...@elasticsearch.com](mailto:shay.ba...@elasticsearch.com) wrote:
> Can you gist a curl recreation with setting up the data (and mappings)?
>
> On Mon, Nov 1, 2010 at 10:09 AM, yingsun cheng [xingrongch...@gmail.com](mailto:xingrongch...@gmail.com)wrote:
>
> > Hi,
> > Can anybody help me? When I'm using "script" in my search query,
> > there are some excetions happens:
> > ========== Request ===============
> > curl -XGET '[http://localhost:9200/twitter/user/\_search](http://localhost:9200/twitter/user/_search)?
> > pretty=true' -d '
> > {
> > "query" : {
> > "filtered" : {
> > "query" : {
> > "match\_all": {}
> > },
> > "filter" : {
> > "script" : {
> > "script" : "doc['age'].value \> 20"
> > }
> > }
> > }
> > }
> > }'
> > =========== Response ===============
> > {
> > "\_shards" : {
> > "total" : 5,
> > "successful" : 3,
> > "failed" : 2,
> > "failures" : [ {
> > "index" : "twitter",
> > "shard" : 4,
> > "reason" : "QueryPhaseExecutionException[[twitter][4]:
>
> > query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAl lDocsFilter@aecd51
> > ))-
> >
> > > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > > [Failed to execute main query]]; nested: CompileException[[Error: No
> > > field found for
> > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]]
> > > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > > nested: ElasticSearchIllegalArgumentException[No field found for
> > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]];
> > > "
> > > }, {
> > > "index" : "twitter",
> > > "shard" : 2,
> > > "reason" : "QueryPhaseExecutionException[[twitter][2]:
>
> > query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAl lDocsFilter@aecd51
> > ))-
> >
> > > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > > [Failed to execute main query]]; nested: CompileException[[Error: No
> > > field found for
> > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]]
> > > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > > nested: ElasticSearchIllegalArgumentException[No field found for
> > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]];
> > > "
> > > } ]
> > > },
> > > "hits" : {
> > > "total" : 0,
> > > "max\_score" : null,
> > > "hits" :
> > > }
> > > }
> > > =========== Type Mapping ===================
> > > {
> > > "user": {
> > > "properties": {
> > > "name": {
> > > "type": "string",
> > > "index": "not\_analyzed"
> > > },
> > > "passwd": {
> > > "type": "string",
> > > "index": "no"
> > > },
> > > "sex": {
> > > "type": "boolean",
> > > "index": "yes",
> > > "null\_value" : "no"
> > > },
> > > "age": {
> > > "type": "integer",
> > > "index": "yes",
> > > "null\_value" : 0
> > > },
> > > "email": {
> > > "type": "string"
> > > },
> > > "address": {
> > > "type": "string"
> > > }
> > > }
> > > }
> > > }
---
### Author:  [@kimchy](https://discuss.elastic.co/u/kimchy)
#### Post date: [November 2, 2010, 8:26am UTC](https://discuss.elastic.co/t/scripting-exception/3496/4 "2010-11-02T08:26:41Z")
Hi,
It seems like its a problem with curl and using the ' sign. Its used
around age, and to denote the HTTP body for curl, Try this one:
curl -XGET '[http://localhost:9200/twitter/user/\_search?pretty=true](http://localhost:9200/twitter/user/_search?pretty=true)' -d '
{
"query": {
"filtered": {
"query": {
"match\_all": {}
},
"filter": {
"script": {
"script": "doc["age"].value == 25"
}
}
}
}
}'
2010/11/2 yingsun cheng [xingrongcheng@gmail.com](mailto:xingrongcheng@gmail.com)
> // Using elasticsearch-0.12.1
> // Creat Index:
> curl -XPUT '[http://localhost:9200/twitter/](http://localhost:9200/twitter/)'
>
> // Put Mapping
> curl -XPUT '[http://localhost:9200/twitter/user/\_mapping](http://localhost:9200/twitter/user/_mapping)' -d '
> {
> "user": {
> "properties": {
> "name": {
> "type": "string",
> "index": "not\_analyzed"
> },
> "age": {
> "type": "integer",
> "null\_value" : 0
> }
> }
> }
> }'
>
> // Index
> curl -XPOST '[http://localhost:9200/twitter/user/](http://localhost:9200/twitter/user/)' -d '
> {
> "name": "amdin",
> "age": 25
> }'
>
> // Search with Script
> curl -XGET '[http://localhost:9200/twitter/user/\_search?pretty=true](http://localhost:9200/twitter/user/_search?pretty=true)' -d
> '
> {
> "query": {
> "filtered": {
> "query": {
> "match\_all": {}
> },
> "filter": {
> "script": {
> "script": "doc['age'].value \> 25"
> }
> }
> }
> }
> }'
>
> // Then get Excetion
> .....
>
> On 11月1日, 下午9时11分, Shay Banon [shay.ba...@elasticsearch.com](mailto:shay.ba...@elasticsearch.com) wrote:
>
> > Can you gist a curl recreation with setting up the data (and mappings)?
> >
> > On Mon, Nov 1, 2010 at 10:09 AM, yingsun cheng \<[xingrongch...@gmail.com](mailto:xingrongch...@gmail.com)
> > wrote:
> >
> > > Hi,
> > > Can anybody help me? When I'm using "script" in my search query,
> > > there are some excetions happens:
> > > ========== Request ===============
> > > curl -XGET '[http://localhost:9200/twitter/user/\_search](http://localhost:9200/twitter/user/_search)?
> > > pretty=true' -d '
> > > {
> > > "query" : {
> > > "filtered" : {
> > > "query" : {
> > > "match\_all": {}
> > > },
> > > "filter" : {
> > > "script" : {
> > > "script" : "doc['age'].value \> 20"
> > > }
> > > }
> > > }
> > > }
> > > }'
> > > =========== Response ===============
> > > {
> > > "\_shards" : {
> > > "total" : 5,
> > > "successful" : 3,
> > > "failed" : 2,
> > > "failures" : [ {
> > > "index" : "twitter",
> > > "shard" : 4,
> > > "reason" : "QueryPhaseExecutionException[[twitter][4]:
> >
> > >
>
> query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAl
> lDocsFilter@aecd51
>
> > > ))-
> > >
> > > > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > > > [Failed to execute main query]]; nested: CompileException[[Error: No
> > > > field found for
> > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]]
> > > > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > > > nested: ElasticSearchIllegalArgumentException[No field found for
> > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]];
> > > > "
> > > > }, {
> > > > "index" : "twitter",
> > > > "shard" : 2,
> > > > "reason" : "QueryPhaseExecutionException[[twitter][2]:
> >
> > >
>
> query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAl
> lDocsFilter@aecd51
>
> > > ))-
> > >
> > > > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > > > [Failed to execute main query]]; nested: CompileException[[Error: No
> > > > field found for
> > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]]
> > > > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > > > nested: ElasticSearchIllegalArgumentException[No field found for
> > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]];
> > > > "
> > > > } ]
> > > > },
> > > > "hits" : {
> > > > "total" : 0,
> > > > "max\_score" : null,
> > > > "hits" :
> > > > }
> > > > }
> > > > =========== Type Mapping ===================
> > > > {
> > > > "user": {
> > > > "properties": {
> > > > "name": {
> > > > "type": "string",
> > > > "index": "not\_analyzed"
> > > > },
> > > > "passwd": {
> > > > "type": "string",
> > > > "index": "no"
> > > > },
> > > > "sex": {
> > > > "type": "boolean",
> > > > "index": "yes",
> > > > "null\_value" : "no"
> > > > },
> > > > "age": {
> > > > "type": "integer",
> > > > "index": "yes",
> > > > "null\_value" : 0
> > > > },
> > > > "email": {
> > > > "type": "string"
> > > > },
> > > > "address": {
> > > > "type": "string"
> > > > }
> > > > }
> > > > }
> > > > }
---
### Author:  [@yingsun\_cheng](https://discuss.elastic.co/u/yingsun_cheng)
#### Post date: [November 3, 2010, 12:51am UTC](https://discuss.elastic.co/t/scripting-exception/3496/5 "2010-11-03T00:51:33Z")
It works. Thank you!
On 11月2日, 下午4时26分, Shay Banon [shay.ba...@elasticsearch.com](mailto:shay.ba...@elasticsearch.com) wrote:
> Hi,
>
> It seems like its a problem with curl and using the ' sign. Its used
> around age, and to denote the HTTP body for curl, Try this one:
>
> curl -XGET '[http://localhost:9200/twitter/user/\_search?pretty=true'-d](http://localhost:9200/twitter/user/_search?pretty=true'-d) '
> {
> "query": {
> "filtered": {
> "query": {
> "match\_all": {}
> },
> "filter": {
> "script": {
> "script": "doc["age"].value == 25"
> }
> }
> }
> }
>
> }'
>
> 2010/11/2 yingsun cheng [xingrongch...@gmail.com](mailto:xingrongch...@gmail.com)
>
> > // Using elasticsearch-0.12.1
> > // Creat Index:
> > curl -XPUT '[http://localhost:9200/twitter/](http://localhost:9200/twitter/)'
>
> > // Put Mapping
> > curl -XPUT '[http://localhost:9200/twitter/user/\_mapping'-d](http://localhost:9200/twitter/user/_mapping'-d) '
> > {
> > "user": {
> > "properties": {
> > "name": {
> > "type": "string",
> > "index": "not\_analyzed"
> > },
> > "age": {
> > "type": "integer",
> > "null\_value" : 0
> > }
> > }
> > }
> > }'
>
> > // Index
> > curl -XPOST '[http://localhost:9200/twitter/user/'-d](http://localhost:9200/twitter/user/'-d) '
> > {
> > "name": "amdin",
> > "age": 25
> > }'
>
> > // Search with Script
> > curl -XGET '[http://localhost:9200/twitter/user/\_search?pretty=true'-d](http://localhost:9200/twitter/user/_search?pretty=true'-d)
> > '
> > {
> > "query": {
> > "filtered": {
> > "query": {
> > "match\_all": {}
> > },
> > "filter": {
> > "script": {
> > "script": "doc['age'].value \> 25"
> > }
> > }
> > }
> > }
> > }'
>
> > // Then get Excetion
> > .....
>
> > On 11月1日, 下午9时11分, Shay Banon [shay.ba...@elasticsearch.com](mailto:shay.ba...@elasticsearch.com) wrote:
> >
> > > Can you gist a curl recreation with setting up the data (and mappings)?
>
> > > On Mon, Nov 1, 2010 at 10:09 AM, yingsun cheng \<[xingrongch...@gmail.com](mailto:xingrongch...@gmail.com)
> > > wrote:
>
> > > > Hi,
> > > > Can anybody help me? When I'm using "script" in my search query,
> > > > there are some excetions happens:
> > > > ========== Request ===============
> > > > curl -XGET '[http://localhost:9200/twitter/user/\_search](http://localhost:9200/twitter/user/_search)?
> > > > pretty=true' -d '
> > > > {
> > > > "query" : {
> > > > "filtered" : {
> > > > "query" : {
> > > > "match\_all": {}
> > > > },
> > > > "filter" : {
> > > > "script" : {
> > > > "script" : "doc['age'].value \> 20"
> > > > }
> > > > }
> > > > }
> > > > }
> > > > }'
> > > > =========== Response ===============
> > > > {
> > > > "\_shards" : {
> > > > "total" : 5,
> > > > "successful" : 3,
> > > > "failed" : 2,
> > > > "failures" : [ {
> > > > "index" : "twitter",
> > > > "shard" : 4,
> > > > "reason" : "QueryPhaseExecutionException[[twitter][4]:
>
> > query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAl
> > lDocsFilter@aecd51
> >
> > > > ))-
> > > >
> > > > > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > > > > [Failed to execute main query]]; nested: CompileException[[Error: No
> > > > > field found for
> > > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]]
> > > > > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > > > > nested: ElasticSearchIllegalArgumentException[No field found for
> > > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@17fdc2d]];
> > > > > "
> > > > > }, {
> > > > > "index" : "twitter",
> > > > > "shard" : 2,
> > > > > "reason" : "QueryPhaseExecutionException[[twitter][2]:
>
> > query[filtered(ConstantScore(org.elasticsearch.common.lucene.search.MatchAl
> > lDocsFilter@aecd51
> >
> > > > ))-
> > > >
> > > > > ScriptFilter(doc[age].value \> 20)],from[0],size[10]: Query Failed
> > > > > [Failed to execute main query]]; nested: CompileException[[Error: No
> > > > > field found for
> > > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]]
> > > > > \n[Near : {... Unknown ....}]\n ^\n[Line: 1, Column: 0]];
> > > > > nested: ElasticSearchIllegalArgumentException[No field found for
> > > > > [org.elasticsearch.index.field.data.longs.LongDocFieldData@19f5d89]];
> > > > > "
> > > > > } ]
> > > > > },
> > > > > "hits" : {
> > > > > "total" : 0,
> > > > > "max\_score" : null,
> > > > > "hits" :
> > > > > }
> > > > > }
> > > > > =========== Type Mapping ===================
> > > > > {
> > > > > "user": {
> > > > > "properties": {
> > > > > "name": {
> > > > > "type": "string",
> > > > > "index": "not\_analyzed"
> > > > > },
> > > > > "passwd": {
> > > > > "type": "string",
> > > > > "index": "no"
> > > > > },
> > > > > "sex": {
> > > > > "type": "boolean",
> > > > > "index": "yes",
> > > > > "null\_value" : "no"
> > > > > },
> > > > > "age": {
> > > > > "type": "integer",
> > > > > "index": "yes",
> > > > > "null\_value" : 0
> > > > > },
> > > > > "email": {
> > > > > "type": "string"
> > > > > },
> > > > > "address": {
> > > > > "type": "string"
> > > > > }
> > > > > }
> > > > > }
> > > > > }
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 4:17am UTC](https://discuss.elastic.co/t/scripting-exception/3496/6 "2017-07-06T04:17:16Z")