How to insert data into elasticsearch
If you are using KIBANA with elasticsearch then you can use below RESt request to create and put in the index.
CREATING INDEX:
http://localhost:9200/company
PUT company
{
"settings": {
"index": {
"number_of_shards": 1,
"number_of_replicas": 1
},
"analysis": {
"analyzer": {
"analyzer-name": {
"type": "custom",
"tokenizer": "keyword",
"filter": "lowercase"
}
}
}
},
"mappings": {
"employee": {
"properties": {
"age": {
"type": "long"
},
"experience": {
"type": "long"
},
"name": {
"type": "text",
"analyzer": "analyzer-name"
}
}
}
}
}
CREATING DOCUMENT:
POST http://localhost:9200/company/employee/2/_create
{
"name": "Hemani",
"age" : 23,
"experienceInYears" : 2
}
Let me explain clearly.. If you are familiar With rdbms.. Index is database.. And index type is table.. It mean index is collection of index types., like collection of tables as database (DB).
in NOSQL.. Index is database and index type is collections. Group of collection as database..
To execute those queries... U need to install CURL for Windows.
Curl is nothing but a command line rest tool.. If you want a graphical tool.. Try
Sense plugin for chrome...
Hope it helps..
To test and try curl requests from Windows, you can make use of Postman client Chrome extension. It is very simple to use and quite powerful.
Or as suggested you can install the cURL util.
A sample curl request is as follows.
curl -X POST -H "Content-Type: application/json" -H "Cache-Control: no-cache" -d '{
"user" : "Arun Thundyill Saseendran",
"post_date" : "2009-03-23T12:30:00",
"message" : "trying out Elasticsearch"
}' "http://10.103.102.56:9200/sampleindex/sampletype/"
I am also getting started with and exploring ES in vast. So please let me know if you have any other doubts.
EDIT: Updated the index name and type name to be fully lowercase to avoid errors and follow convention.
You have to install the curl
binary in your PC first. You can download it from here.
After that unzip it into a folder. Lets say C:\curl
. In that folder you'll find curl.exe
file with several .dll
files.
Now open a command prompt by typing cmd
from the start menu
. And type cd c:\curl
on there and it will take you to the curl folder. Now execute the curl
command that you have.
One thing, windows doesn't support single quote around around the fields. So you have to use double quotes. For example I have converted your curl command like appropriate one.
curl -H "Content-Type: application/json" -XPOST "http://localhost:9200/indexname/typename/optionalUniqueId" -d "{ \"field\" : \"value\"}"