Elasticsearch: how can i create mapping before upload json data into Elasticsearch

Question

I'm trying to create mapping before uploading json data into elasticsearch. I don't know how to implement mapping before uploading json data in sails.js

This is my bulkupload snippet

     var body = [];
      //row is json data
        rows.forEach(function(row, id) {
             body.push({ index:  { _index: 'testindex', _type: 'testtype', _id: (id+1) } });
             body.push(row);
        })  
    client.bulk({
                    body: body
                }, function (err, resp) {
                        if (err) 
                        {
                            console.log(err);
                            return;
                       }
                      else 
                      { 
                            console.log("All Is Well");
                      }
      });

I want to create mapping before data upload.can any one know how to create mapping in sails.

my Json object

 [ { Name: 'paranthn', Age: '43', Address: 'trichy' },
      { Name: 'Arthick', Age: '23', Address: 'trichy' },
      { Name: 'vel', Age: '24', Address: 'trichy' } ]

Val · Accepted Answer · 2015-09-09 04:46:04Z

2

Before making your client.bulk() call you first need to make another client.indices.putMapping() call like this in order to save the correct mapping for the data you're about to send via the bulk call:

client.indices.putMapping({
   "index": "testindex",
   "type": "testtype",
   "body": {
      "testtype": {
          "properties": {
              "your_int_field": {
                  "type": "integer"
              },
              "your_string_field": {
                  "type": "string"
              },
              "your_double_field": {
                  "type": "double"
              },
              // your other fields
          }
      }
   }
}, function (err, response) {
   // from this point on, if you don't get any error, you may call bulk.
});

Remember that all these calls are asynchronous, so be careful to only call bulk once putMapping has returned successfully.

edited Sep 9, 2015 at 4:46

answered Sep 8, 2015 at 12:02

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Martin Over a year ago

Hi val it works fine for me. but i json object returs everythig as a string but in my properties i need to set property as a integer how can i acheive that.

Martin Over a year ago

The number of fields in the JSON may be dynamic. Then how can I do mapping for this ? i have updated sample json data in my question please refer.

Cody Gray · Accepted Answer · 2017-08-08 12:51:39Z

1

Sounds like you need PutMapping.

edited Aug 8, 2017 at 12:51

Cody Gray♦

246k53 gold badges514 silver badges591 bronze badges

answered Sep 8, 2015 at 9:14

Science_Fiction

3,44325 silver badges30 bronze badges

1 Comment

Martin Over a year ago

But i need to do mapping in sails.js before that bulk upload functionality.Is this possible to do?

Collectives™ on Stack Overflow

Elasticsearch: how can i create mapping before upload json data into Elasticsearch

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related