- .NET Clients: other versions:
- Introduction
- Installation
- Breaking changes
- API Conventions
- Elasticsearch.Net - Low level client
- NEST - High level client
- Troubleshooting
- Search
- Query DSL
- Full text queries
- Term level queries
- Exists Query Usage
- Fuzzy Date Query Usage
- Fuzzy Numeric Query Usage
- Fuzzy Query Usage
- Ids Query Usage
- Prefix Query Usage
- Date Range Query Usage
- Long Range Query Usage
- Numeric Range Query Usage
- Term Range Query Usage
- Regexp Query Usage
- Term Query Usage
- Terms Set Query Usage
- Terms List Query Usage
- Terms Lookup Query Usage
- Terms Query Usage
- Wildcard Query Usage
- Compound queries
- Joining queries
- Geo queries
- Specialized queries
- Span queries
- NEST specific queries
- Aggregations
- Metric Aggregations
- Average Aggregation Usage
- Boxplot Aggregation Usage
- Cardinality Aggregation Usage
- Extended Stats Aggregation Usage
- Geo Bounds Aggregation Usage
- Geo Centroid Aggregation Usage
- Geo Line Aggregation Usage
- Max Aggregation Usage
- Median Absolute Deviation Aggregation Usage
- Min Aggregation Usage
- Percentile Ranks Aggregation Usage
- Percentiles Aggregation Usage
- Rate Aggregation Usage
- Scripted Metric Aggregation Usage
- Stats Aggregation Usage
- String Stats Aggregation Usage
- Sum Aggregation Usage
- T Test Aggregation Usage
- Top Hits Aggregation Usage
- Top Metrics Aggregation Usage
- Value Count Aggregation Usage
- Weighted Average Aggregation Usage
- Bucket Aggregations
- Adjacency Matrix Usage
- Auto Date Histogram Aggregation Usage
- Children Aggregation Usage
- Composite Aggregation Usage
- Date Histogram Aggregation Usage
- Date Range Aggregation Usage
- Diversified Sampler Aggregation Usage
- Filter Aggregation Usage
- Filters Aggregation Usage
- Geo Distance Aggregation Usage
- Geo Hash Grid Aggregation Usage
- Geo Tile Grid Aggregation Usage
- Global Aggregation Usage
- Histogram Aggregation Usage
- Ip Range Aggregation Usage
- Missing Aggregation Usage
- Multi Terms Aggregation Usage
- Nested Aggregation Usage
- Parent Aggregation Usage
- Range Aggregation Usage
- Rare Terms Aggregation Usage
- Reverse Nested Aggregation Usage
- Sampler Aggregation Usage
- Significant Terms Aggregation Usage
- Significant Text Aggregation Usage
- Terms Aggregation Usage
- Variable Width Histogram Usage
- Pipeline Aggregations
- Average Bucket Aggregation Usage
- Bucket Script Aggregation Usage
- Bucket Selector Aggregation Usage
- Bucket Sort Aggregation Usage
- Cumulative Cardinality Aggregation Usage
- Cumulative Sum Aggregation Usage
- Derivative Aggregation Usage
- Extended Stats Bucket Aggregation Usage
- Max Bucket Aggregation Usage
- Min Bucket Aggregation Usage
- Moving Average Ewma Aggregation Usage
- Moving Average Holt Linear Aggregation Usage
- Moving Average Holt Winters Aggregation Usage
- Moving Average Linear Aggregation Usage
- Moving Average Simple Aggregation Usage
- Moving Function Aggregation Usage
- Moving Percentiles Aggregation Usage
- Normalize Aggregation Usage
- Percentiles Bucket Aggregation Usage
- Serial Differencing Aggregation Usage
- Stats Bucket Aggregation Usage
- Sum Bucket Aggregation Usage
- Matrix Aggregations
- Metric Aggregations
Multi fields
editMulti fields
editIt is often useful to index the same field in Elasticsearch in different ways, to
serve different purposes, for example, mapping a POCO string
property as a
text
datatype for full text search as well as mapping as a keyword
datatype for
structured search, sorting and aggregations. Another example is mapping a POCO string
property to use different analyzers, to serve different full text search needs.
Let’s look at a few examples. for each, we use the following simple POCO
public class Person { public string Name { get; set; } }
Default mapping for String properties
editWhen using Auto Mapping, the inferred mapping for a string
POCO type is a text
datatype with multi fields including a keyword
sub field
var createIndexResponse = _client.Indices.Create("myindex", c => c .Map<Person>(m => m .AutoMap() ) );
This results in the following JSON request
{ "mappings": { "properties": { "name": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } } } } }
This is useful because the property can be used for both full text search as well as for structured search, sorting and aggregations
var searchResponse = _client.Search<Person>(s => s .Query(q => q .Match(m => m .Field(f => f.Name) .Query("Russ") ) ) .Sort(ss => ss .Descending(f => f.Name.Suffix("keyword")) ) .Aggregations(a => a .Terms("peoples_names", t => t .Field(f => f.Name.Suffix("keyword")) ) ) );
{ "query": { "match": { "name": { "query": "Russ" } } }, "sort": [ { "name.keyword": { "order": "desc" } } ], "aggs": { "peoples_names": { "terms": { "field": "name.keyword" } } } }
Multi fields do not change the original _source
field in Elasticsearch; they affect only how
a field is indexed.
New multi fields can be added to existing fields using the Put Mapping API.
Creating Multi fields
editMulti fields can be created on a mapping using the .Fields()
method within a field mapping
var createIndexResponse = _client.Indices.Create("myindex", c => c .Map<Person>(m => m .Properties(p => p .Text(t => t .Name(n => n.Name) .Fields(ff => ff .Text(tt => tt .Name("stop") .Analyzer("stop") ) .Text(tt => tt .Name("shingles") .Analyzer("name_shingles") ) .Keyword(k => k .Name("keyword") .IgnoreAbove(256) ) ) ) ) ) );
Use the stop analyzer on this sub field |
|
Use a custom analyzer named "named_shingles" that is configured in the index |
|
Index as not analyzed |
{ "mappings": { "properties": { "name": { "type": "text", "fields": { "stop": { "type": "text", "analyzer": "stop" }, "shingles": { "type": "text", "analyzer": "name_shingles" }, "keyword": { "type": "keyword", "ignore_above": 256 } } } } } }