Unable to load json mapping Elasticsearch

Question

I'm trying to map a json structure on Elasticsearch but something seems to be wrong because when I launch the curl command from my Windows prompt nothing appends except the underscore pulsing.

I use this curl command:

curl -H "Content-Type: application/json" -XPUT http://localhost:9200/technogym -d "{\"mappings\":{\"id\":{\"type\":\"string\"},\"key\":{\"type\":\"string\"},\"value\":{\"type\":\"object\",\"properties\":{\"rev\":{\"type\":\"string\"}}},\"doc\":{\"type\":\"object\",\"properties\":{\"_id\":{\"type\":\"string\"},\"_rev\":{\"type\":\"string\"},\"userID\":{\"type\":\"string\"},\"conversation_id\":{\"type\":\"string\"},\"input\":{\"type\":\"object\",\"properties\":{\"text\":{\"type\":\"string\"}}},\"output\":{\"type\":\"object\",\"properties\":{\"text\":{\"type\":\"string\"}}},\"node_visited\":{\"type\":\"string\"},\"intents\":{\"properties\":{\"intent\":{\"type\":\"string\"},\"confidence\":{\"type\":\"string\"}}},\"entities\":{\"type\":\"object\",\"properties\":{\"entity\":{\"type\":\"string\"},\"location\":{\"type\":\"string\"},\"value\":{\"type\":\"string\"},\"confidence\":{\"type\":\"string\"}}},\"timestamp\":{\"type\":\"date\"}}}}}"

Here my jsonwith mapping (just to make it more readable):

EDIT

{"mappings": {
"_default_": {
  "properties": {
    "id": {
      "type": "string"
    },
    "key": {
      "type": "string"
    },
    "value": {
      "type": "object",
      "properties": {
        "rev": {
          "type": "string"
        }
      }
    },
    "doc": {
      "type": "object",
      "properties": {
        "_id": {
          "type": "string"
        },
        "_rev": {
          "type": "string"
        },
        "userID": {
          "type": "string"
        },
        "conversation_id": {
          "type": "string"
        },
        "input": {
          "type": "object",
          "properties": {
            "text": {
              "type": "string"
            }
          }
        },
        "output": {
          "type": "object",
          "properties": {
            "text": {
              "type": "string"
            }
          }
        },
        "node_visited": {
          "type": "string"
        },
        "intents": {
          "properties": {
            "intent": {
              "type": "string"
            },
            "confidence": {
              "type": "string"
            }
          }
        },
        "entities": {
          "type": "object",
          "properties": {
            "entity": {
              "type": "string"
            },
            "location": {
              "type": "string"
            },
            "value": {
              "type": "string"
            },
            "confidence": {
              "type": "string"
            }
          }
        },
        "timestamp": {
          "type": "date"
        }
      }
    }
  }
}}}

I don't know why I can't upload this mapping.

Thanks for any help.

prayagupadhyay · Accepted Answer · 2017-05-15 09:53:57Z

create an index

curl -XPUT localhost:9200/technogym
{"acknowledged":true}

Then apply your mapping to whatever type you want, eg. technogym_type

curl -X PUT localhost:9200/technogym/technogym_type/_mapping -d '{
  "properties": {
    "id": {
      "type": "string"
    },
    "key": {
      "type": "string"
    },
    "value": {
      "type": "object",
      "properties": {
        "rev": {
          "type": "string"
        }
      }
    },
    "doc": {
      "type": "object",
      "properties": {
        "_id": {
          "type": "string"
        },
        "_rev": {
          "type": "string"
        },
        "userID": {
          "type": "string"
        },
        "conversation_id": {
          "type": "string"
        },
        "input": {
          "type": "object",
          "properties": {
            "text": {
              "type": "string"
            }
          }
        },
        "output": {
          "type": "object",
          "properties": {
            "text": {
              "type": "string"
            }
          }
        },
        "node_visited": {
          "type": "string"
        },
        "intents": {
          "properties": {
            "intent": {
              "type": "string"
            },
            "confidence": {
              "type": "string"
            }
          }
        },
        "entities": {
          "type": "object",
          "properties": {
            "entity": {
              "type": "string"
            },
            "location": {
              "type": "string"
            },
            "value": {
              "type": "string"
            },
            "confidence": {
              "type": "string"
            }
          }
        },
        "timestamp": {
          "type": "date"
        }
      }
    }
  }
}'

{"acknowledged":true}

But if you dynamically want to create index and mappings, just fix your JSON document where it needs mappings (plural) and followed by the name of the type you want. (type equivalent to RDBMS table name)

curl -X PUT localhost:9200/technogym1 -d '
{
  "mappings": {
    "technogym_type1": {
      "properties": {
        "id": {
          "type": "string"
        },
        "key": {
          "type": "string"
        },
        "value": {
          "type": "object",
          "properties": {
            "rev": {
              "type": "string"
            }
          }
        },
        "doc": {
          "type": "object",
          "properties": {
            "_id": {
              "type": "string"
            },
            "_rev": {
              "type": "string"
            },
            "userID": {
              "type": "string"
            },
            "conversation_id": {
              "type": "string"
            },
            "input": {
              "type": "object",
              "properties": {
                "text": {
                  "type": "string"
                }
              }
            },
            "output": {
              "type": "object",
              "properties": {
                "text": {
                  "type": "string"
                }
              }
            },
            "node_visited": {
              "type": "string"
            },
            "intents": {
              "properties": {
                "intent": {
                  "type": "string"
                },
                "confidence": {
                  "type": "string"
                }
              }
            },
            "entities": {
              "type": "object",
              "properties": {
                "entity": {
                  "type": "string"
                },
                "location": {
                  "type": "string"
                },
                "value": {
                  "type": "string"
                },
                "confidence": {
                  "type": "string"
                }
              }
            },
            "timestamp": {
              "type": "date"
            }
          }
        }
      }
    }
  }
}'
{"acknowledged":true,"shards_acknowledged":true}

Thank you ;). Yes I've edited with the right json because in my right one there is "mappings" instead of "mapping". Thanks for the help again it has turned out very usefull
great that it worked for you. if you want to create index first (equivalent to database name in RDBMS) and then type mapping, then follow first answer otherwise, your way of doing is correct too. You can verify mappings with http://localhost:9200/technogym1/technogym_type1/_mapping?pretty=true

Richa · Accepted Answer · 2017-05-15 09:47:10Z

1

You need to change mapping to mappings.

{
"mappings": {                ==> change this
"_default_": {
"properties": {
"id": {
  "type": "string"
},
"key": {
  "type": "string"
},
"value": {
  "type": "object",
  "properties": {
    "rev": {
      "type": "string"
    }
  }
},
"doc": {
  "type": "object",
  "properties": {
    "_id": {
      "type": "string"
    },
    "_rev": {
      "type": "string"
    },
    "userID": {
      "type": "string"
    },
    "conversation_id": {
      "type": "string"
    },
    "input": {
      "type": "object",
      "properties": {
        "text": {
          "type": "string"
        }
      }
    },
    "output": {
      "type": "object",
      "properties": {
        "text": {
          "type": "string"
        }
      }
    },
    "node_visited": {
      "type": "string"
    },
    "intents": {
      "properties": {
        "intent": {
          "type": "string"
        },
        "confidence": {
          "type": "string"
        }
      }
    },
    "entities": {
      "type": "object",
      "properties": {
        "entity": {
          "type": "string"
        },
        "location": {
          "type": "string"
        },
        "value": {
          "type": "string"
        },
        "confidence": {
          "type": "string"
        }
      }
    },
    "timestamp": {
      "type": "date"
       }
       }}}}}}

answered May 15, 2017 at 9:47

Richa

7,6796 gold badges30 silver badges36 bronze badges

1 Comment

Filippo Leoncini Over a year ago

Sorry you are right, I've posted a wrong json but in my right one is mappings. Now I edit the question. Thanks

Collectives™ on Stack Overflow

Unable to load json mapping Elasticsearch

2 Answers 2

2 Comments

1 Comment

Your Answer

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

Related