Loading Some Relational Data
We will use a simple synthetic dataset for the purpose of this demo. The dataset consists of two collections of documents: Articles and Companies. An article is connected to a company with the attribute mentions
. Articles will be loaded into the articles
index and companies in the companies
index. To load the dataset, run the following command:
$ curl -H 'Content-Type: application/json' -XPUT 'http://localhost:9200/articles' $ curl -H 'Content-Type: application/json' -XPUT 'http://localhost:9200/articles/_mapping/article' -d ' { "properties": { "mentions": { "type": "keyword" } } } ' $ curl -H 'Content-Type: application/json' -XPUT 'http://localhost:9200/companies' $ curl -H 'Content-Type: application/json' -XPUT 'http://localhost:9200/companies/_mapping/company' -d ' { "properties": { "id": { "type": "keyword" } } } ' $ curl -H 'Content-Type: application/json' -XPUT 'http://localhost:9200/_bulk?pretty' -d ' { "index" : { "_index" : "articles", "_type" : "article", "_id" : "1" } } { "title" : "The NoSQL database glut", "mentions" : ["1", "2"] } { "index" : { "_index" : "articles", "_type" : "article", "_id" : "2" } } { "title" : "Graph Databases Seen Connecting the Dots", "mentions" : [] } { "index" : { "_index" : "articles", "_type" : "article", "_id" : "3" } } { "title" : "How to determine which NoSQL DBMS best fits your needs", "mentions" : ["2", "4"] } { "index" : { "_index" : "articles", "_type" : "article", "_id" : "4" } } { "title" : "MapR ships Apache Drill", "mentions" : ["4"] } { "index" : { "_index" : "companies", "_type" : "company", "_id" : "1" } } { "id": "1", "name" : "Elastic" } { "index" : { "_index" : "companies", "_type" : "company", "_id" : "2" } } { "id": "2", "name" : "Orient Technologies" } { "index" : { "_index" : "companies", "_type" : "company", "_id" : "3" } } { "id": "3", "name" : "Cloudera" } { "index" : { "_index" : "companies", "_type" : "company", "_id" : "4" } } { "id": "4", "name" : "MapR" } ' { "took" : 8, "errors" : false, "items" : [ { "index" : { "_index" : "articles", "_type" : "article", "_id" : "1", "_version" : 3, "status" : 200 } }, ... }