I have made this mapping using jdbc river plugin for Elasticsearch:
localhost:9200/_river/product/_meta
{
"type": "jdbc",
"jdbc": {
"url": "jdbc:sqlserver://db.example.com;databaseName=training2",
"user": "root",
"password": "",
"sql": "SELECT uuid as uuid, caption as caption FROM caption_processed",
"index": "example",
"type": "product"
}
,
"type_mapping": {
"product" : {
"properties" : {
"caption" : {
"type" : "completion"
}
}
}
}}
And I made this query to test the suggest function:
localhost:9200//example/_suggest
{"product" : {
"text" : "",
"completion" : {
"field" : "content"
}}
}
This is the error that I get:
{
"_shards": {
"total": 5,
"successful": 0,
"failed": 5,
"failures": [
{
"index": "example",
"shard": 0,
"reason": "BroadcastShardOperationFailedException[[example][0] ];
nested: ElasticsearchException[failed to execute suggest]; nested:
ClassCastException[org.elasticsearch.index.mapper.core.StringFieldMapper cannot
be cast to org.elasticsearch.index.mapper.core.CompletionFieldMapper]; "
},
{
"index": "example",
"shard": 1,
"reason": "BroadcastShardOperationFailedException[[example][1] ];
nested: ElasticsearchException[failed to execute suggest]; nested:
ClassCastException[org.elasticsearch.index.mapper.core.StringFieldMapper cannot
be cast to org.elasticsearch.index.mapper.core.CompletionFieldMapper]; "
},
........................... }
Do you have any idea about what I'm doing wrongly?
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/d587a220-9dff-4bd0-a8a2-6d1713042579%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
