Will it reindex when use script filter on a string type field?


(zouxcs) #1

I store numbers by using string type.when i filter these use script filter
range like this:

{
"query": {
"filtered": {
"query": {
"match_all": {}
},
"filter": {
"nested": {
"path": "pt_account",
"filter": {
"bool": {
"must": [

            {
              "term": {
                "column": "mobile_account"
              }
            },
            {
              "script" : {
                "script" : "doc['value'].value >= param1 and 

doc['value'].value <= param2",
"params" : {
"param1" : "15091568126",
"param2" : "15191568126"
}
}
}

          ]
        }
      }
    }
  }
}

}
}

Will this field value reindex when i filter like that,how do i to Improve
Performance ? Thank you!

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ded279aa-78c9-4b3e-9959-9548b47c8e24%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(David Pilato) #2

No.

You need to reindex your data if you want to add a new field.
Have a look at http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/docs-update.html

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 10 juil. 2014 à 05:06, Charles Chou zouxcs@gmail.com a écrit :

I store numbers by using string type.when i filter these use script filter range like this:

{
"query": {
"filtered": {
"query": {
"match_all": {}
},
"filter": {
"nested": {
"path": "pt_account",
"filter": {
"bool": {
"must": [

            {
              "term": {
                "column": "mobile_account"
              }
            },
            {
              "script" : {
                "script" : "doc['value'].value >= param1 and doc['value'].value <= param2",
                "params" : {
                  "param1" : "15091568126",
                  "param2" : "15191568126"
                }
              }
            }
           
          ]
        }
      }
    }
  }
}

}
}

Will this field value reindex when i filter like that,how do i to Improve Performance ? Thank you!

You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ded279aa-78c9-4b3e-9959-9548b47c8e24%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/4127C4F2-9988-4A81-807B-069DFD728B54%40pilato.fr.
For more options, visit https://groups.google.com/d/optout.


(zouxcs) #3

Thanks for that,I index the field value by string,but I put number in it
,here is the mapping:

{

"dn_item_log_mid": {

    "properties": {

        "dn_item": {

            "type": "nested",

            "properties": {

                "column": {

                    "type": "string",

                    "index": "not_analyzed",

                    "omit_norms": true,

                    "index_options": "docs"

                },

                "value": {

                    "type": "string",

                    "index": "not_analyzed",

                    "omit_norms": true,

                    "index_options": "docs"

                }

            }

        }

    }

}

}

Is it affected?

在 2014年7月10日星期四UTC+8下午2时28分08秒,David Pilato写道:

No.

You need to reindex your data if you want to add a new field.
Have a look at
http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/docs-update.html

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 10 juil. 2014 à 05:06, Charles Chou <zou...@gmail.com <javascript:>> a
écrit :

I store numbers by using string type.when i filter these use script filter
range like this:

{
"query": {
"filtered": {
"query": {
"match_all": {}
},
"filter": {
"nested": {
"path": "pt_account",
"filter": {
"bool": {
"must": [

            {
              "term": {
                "column": "mobile_account"
              }
            },
            {
              "script" : {
                "script" : "doc['value'].value >= param1 and 

doc['value'].value <= param2",
"params" : {
"param1" : "15091568126",
"param2" : "15191568126"
}
}
}

          ]
        }
      }
    }
  }
}

}
}

Will this field value reindex when i filter like that,how do i to Improve
Performance ? Thank you!

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/ded279aa-78c9-4b3e-9959-9548b47c8e24%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/ded279aa-78c9-4b3e-9959-9548b47c8e24%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/b7cf7af1-bf83-4c49-89ce-a15facda9e6e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #4