Elassandra multiple type mapping

Question

I'm using Elassandra to make search in mail, Cassandra to save the mail and ElasticSearch to search in those mails.

My problem is that since ElasticSearch 6, we can't use multiple type in one mapping. Here is my mapping:

"mappings": {
    "mail__mail": {
        "discover" : ".*",
        "properties": {
            "mailfrom": { 
                "type": "text",
                "fields": {
                    "keyword": {
                        "type": "keyword"
                    },
                    "ngram": {
                        "type": "text",
                        "analyzer": "edge_ngram_analyzer",
                        "search_analyzer": "edge_ngram_search_analyzer"
                    }
                }
            },
            "subject": { 
                "type": "text",
                "fields": {
                    "keyword": {
                        "type": "keyword"
                    },
                    "ngram": {
                        "type": "text",
                        "analyzer": "edge_ngram_analyzer",
                        "search_analyzer": "edge_ngram_search_analyzer"
                    }
                }
            },
            "date" : {
                "type" : "date"
            },
            "folderid" : {
                "type" : "text"
            }
        }
    },
    "mail__account" : {
        "discover" : ".*",
        "properties": {
            "userId" : {
                "type" : "Integer"
            }
        }
    }
}

How can i use ElasticSearch 6 to search in multiple cassandra table ?

Answer 1

Since ES6 you need to map 1 table per index. Searching multiple indexes:

https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-index.html

Answer 2

As @Alex said, you need to map 1 table per ES index, but you can create multiple ES indexes per keyspace, mapping to different tables.

You have to specify a keyspace name as an index setting. This is done with the following syntax :

curl -XPUT "http://localhost:9200/your_index/" -d '{
    "settings" : { "keyspace" : "your_keyspace" },
    "mappings" : {
        "your_table" : {
            "properties" : {
                ...
            }
        }
    }
}