Querying data from Elasticsearch

Question

Using Elasticsearch 7.*, trying to execute SQL query on an index 'com-prod':

GET /com-prod/_search
{
  "script_fields": {
    "test1": {
      "script": {
        "lang": "painless",
        "source": "params._source.ElapsedTime"
      }
    }
  }
}

It gives the output and below as one of the hit successfully:

"hits" : [
      {
        "_index" : "com-prod",
        "_type" : "_doc",
        "_id" : "abcd",
        "_score" : 1.0,
        "fields" : {
          "test1" : [
            "29958"
          ]
        }
      }

Now, I am trying to increment the ElapsedTime by 2, as below:

GET /com-prod/_search
{
  "script_fields": {
    "test2": {
      "script": {
        "lang": "painless",
        "source": "params._source.ElapsedTime + 2"
      }
    }
  }
}

But its actually adding number 2 to the output, as below:

"hits" : [
      {
        "_index" : "com-prod",
        "_type" : "_doc",
        "_id" : "abcd",
        "_score" : 1.0,
        "fields" : {
          "test2" : [
            "299582"
          ]
        }
      }

Please guide what could be wrong here, and how to get the output as 29960.

Bhavya · Accepted Answer · 2022-04-05 02:34:08Z

2

You are getting 299582, instead of 29960, because the ElapsedTime field is of string type ("29958"), so when you are adding 2 in this using script, 2 gets appended at the end (similar to concat two strings).

So, in order to solve this issue, you can :

Create a new index, with updated mapping of the ElaspsedTIme field of int type, then reindex the data. Then you can use the same search query as given in the question above.
Convert the string to an int type value, using Integer.parseInt()

GET /com-prod/_search
{
  "script_fields": {
    "test2": {
      "script": {
        "lang": "painless",
        "source": "Integer.parseInt(params._source.ElapsedTime) + 2"
      }
    }
  }
}

answered Apr 5, 2022 at 2:34

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying data from Elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related