Flattened field type
Flattened field type
By default, each subfield in an object is mapped and indexed separately. If the names or types of the subfields are not known in advance, then they are mapped dynamically.
The flattened
type provides an alternative approach, where the entire object is mapped as a single field. Given an object, the flattened
mapping will parse out its leaf values and index them into one field as keywords. The object’s contents can then be searched through simple queries and aggregations.
This data type can be useful for indexing objects with a large or unknown number of unique keys. Only one field mapping is created for the whole JSON object, which can help prevent a mappings explosion from having too many distinct field mappings.
On the other hand, flattened object fields present a trade-off in terms of search functionality. Only basic queries are allowed, with no support for numeric range queries or highlighting. Further information on the limitations can be found in the Supported operations section.
The flattened
mapping type should not be used for indexing all document content, as it treats all values as keywords and does not provide full search functionality. The default approach, where each subfield has its own entry in the mappings, works well in the majority of cases.
A flattened object field can be created as follows:
resp = client.indices.create(
index="bug_reports",
mappings={
"properties": {
"title": {
"type": "text"
},
"labels": {
"type": "flattened"
}
}
},
)
print(resp)
resp1 = client.index(
index="bug_reports",
id="1",
document={
"title": "Results are not sorted correctly.",
"labels": {
"priority": "urgent",
"release": [
"v1.2.5",
"v1.3.0"
],
"timestamp": {
"created": 1541458026,
"closed": 1541457010
}
}
},
)
print(resp1)
response = client.indices.create(
index: 'bug_reports',
body: {
mappings: {
properties: {
title: {
type: 'text'
},
labels: {
type: 'flattened'
}
}
}
}
)
puts response
response = client.index(
index: 'bug_reports',
id: 1,
body: {
title: 'Results are not sorted correctly.',
labels: {
priority: 'urgent',
release: [
'v1.2.5',
'v1.3.0'
],
timestamp: {
created: 1_541_458_026,
closed: 1_541_457_010
}
}
}
)
puts response
const response = await client.indices.create({
index: "bug_reports",
mappings: {
properties: {
title: {
type: "text",
},
labels: {
type: "flattened",
},
},
},
});
console.log(response);
const response1 = await client.index({
index: "bug_reports",
id: 1,
document: {
title: "Results are not sorted correctly.",
labels: {
priority: "urgent",
release: ["v1.2.5", "v1.3.0"],
timestamp: {
created: 1541458026,
closed: 1541457010,
},
},
},
});
console.log(response1);
PUT bug_reports
{
"mappings": {
"properties": {
"title": {
"type": "text"
},
"labels": {
"type": "flattened"
}
}
}
}
POST bug_reports/_doc/1
{
"title": "Results are not sorted correctly.",
"labels": {
"priority": "urgent",
"release": ["v1.2.5", "v1.3.0"],
"timestamp": {
"created": 1541458026,
"closed": 1541457010
}
}
}
During indexing, tokens are created for each leaf value in the JSON object. The values are indexed as string keywords, without analysis or special handling for numbers or dates.
Querying the top-level flattened
field searches all leaf values in the object:
resp = client.search(
index="bug_reports",
query={
"term": {
"labels": "urgent"
}
},
)
print(resp)
response = client.search(
index: 'bug_reports',
body: {
query: {
term: {
labels: 'urgent'
}
}
}
)
puts response
const response = await client.search({
index: "bug_reports",
query: {
term: {
labels: "urgent",
},
},
});
console.log(response);
POST bug_reports/_search
{
"query": {
"term": {"labels": "urgent"}
}
}
To query on a specific key in the flattened object, object dot notation is used:
resp = client.search(
index="bug_reports",
query={
"term": {
"labels.release": "v1.3.0"
}
},
)
print(resp)
response = client.search(
index: 'bug_reports',
body: {
query: {
term: {
'labels.release' => 'v1.3.0'
}
}
}
)
puts response
const response = await client.search({
index: "bug_reports",
query: {
term: {
"labels.release": "v1.3.0",
},
},
});
console.log(response);
POST bug_reports/_search
{
"query": {
"term": {"labels.release": "v1.3.0"}
}
}
Supported operations
Because of the similarities in the way values are indexed, flattened
fields share much of the same mapping and search functionality as keyword fields.
Currently, flattened object fields can be used with the following query types:
term
,terms
, andterms_set
prefix
range
match
andmulti_match
query_string
andsimple_query_string
exists
When querying, it is not possible to refer to field keys using wildcards, as in { "term": {"labels.time*": 1541457010}}
. Note that all queries, including range
, treat the values as string keywords. Highlighting is not supported on flattened
fields.
It is possible to sort on a flattened object field, as well as perform simple keyword-style aggregations such as terms
. As with queries, there is no special support for numerics — all values in the JSON object are treated as keywords. When sorting, this implies that values are compared lexicographically.
Flattened object fields currently cannot be stored. It is not possible to specify the store parameter in the mapping.
Retrieving flattened fields
Field values and concrete subfields can be retrieved using the fields parameter. content. Since the flattened
field maps an entire object with potentially many subfields as a single field, the response contains the unaltered structure from _source
.
Single subfields, however, can be fetched by specifying them explicitly in the request. This only works for concrete paths, but not using wildcards:
resp = client.indices.create(
index="my-index-000001",
mappings={
"properties": {
"flattened_field": {
"type": "flattened"
}
}
},
)
print(resp)
resp1 = client.index(
index="my-index-000001",
id="1",
refresh=True,
document={
"flattened_field": {
"subfield": "value"
}
},
)
print(resp1)
resp2 = client.search(
index="my-index-000001",
fields=[
"flattened_field.subfield"
],
source=False,
)
print(resp2)
response = client.indices.create(
index: 'my-index-000001',
body: {
mappings: {
properties: {
flattened_field: {
type: 'flattened'
}
}
}
}
)
puts response
response = client.index(
index: 'my-index-000001',
id: 1,
refresh: true,
body: {
flattened_field: {
subfield: 'value'
}
}
)
puts response
response = client.search(
index: 'my-index-000001',
body: {
fields: [
'flattened_field.subfield'
],
_source: false
}
)
puts response
const response = await client.indices.create({
index: "my-index-000001",
mappings: {
properties: {
flattened_field: {
type: "flattened",
},
},
},
});
console.log(response);
const response1 = await client.index({
index: "my-index-000001",
id: 1,
refresh: "true",
document: {
flattened_field: {
subfield: "value",
},
},
});
console.log(response1);
const response2 = await client.search({
index: "my-index-000001",
fields: ["flattened_field.subfield"],
_source: false,
});
console.log(response2);
PUT my-index-000001
{
"mappings": {
"properties": {
"flattened_field": {
"type": "flattened"
}
}
}
}
PUT my-index-000001/_doc/1?refresh=true
{
"flattened_field" : {
"subfield" : "value"
}
}
POST my-index-000001/_search
{
"fields": ["flattened_field.subfield"],
"_source": false
}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": 1.0,
"hits": [{
"_index": "my-index-000001",
"_id": "1",
"_score": 1.0,
"fields": {
"flattened_field.subfield" : [ "value" ]
}
}]
}
}
You can also use a Painless script to retrieve values from sub-fields of flattened fields. Instead of including doc['<field_name>'].value
in your Painless script, use doc['<field_name>.<sub-field_name>'].value
. For example, if you have a flattened field called label
with a release
sub-field, your Painless script would be doc['labels.release'].value
.
For example, let’s say your mapping contains two fields, one of which is of the flattened
type:
resp = client.indices.create(
index="my-index-000001",
mappings={
"properties": {
"title": {
"type": "text"
},
"labels": {
"type": "flattened"
}
}
},
)
print(resp)
response = client.indices.create(
index: 'my-index-000001',
body: {
mappings: {
properties: {
title: {
type: 'text'
},
labels: {
type: 'flattened'
}
}
}
}
)
puts response
const response = await client.indices.create({
index: "my-index-000001",
mappings: {
properties: {
title: {
type: "text",
},
labels: {
type: "flattened",
},
},
},
});
console.log(response);
PUT my-index-000001
{
"mappings": {
"properties": {
"title": {
"type": "text"
},
"labels": {
"type": "flattened"
}
}
}
}
Index a few documents containing your mapped fields. The labels
field has three sub-fields:
resp = client.bulk(
index="my-index-000001",
refresh=True,
operations=[
{
"index": {}
},
{
"title": "Something really urgent",
"labels": {
"priority": "urgent",
"release": [
"v1.2.5",
"v1.3.0"
],
"timestamp": {
"created": 1541458026,
"closed": 1541457010
}
}
},
{
"index": {}
},
{
"title": "Somewhat less urgent",
"labels": {
"priority": "high",
"release": [
"v1.3.0"
],
"timestamp": {
"created": 1541458026,
"closed": 1541457010
}
}
},
{
"index": {}
},
{
"title": "Not urgent",
"labels": {
"priority": "low",
"release": [
"v1.2.0"
],
"timestamp": {
"created": 1541458026,
"closed": 1541457010
}
}
}
],
)
print(resp)
response = client.bulk(
index: 'my-index-000001',
refresh: true,
body: [
{
index: {}
},
{
title: 'Something really urgent',
labels: {
priority: 'urgent',
release: [
'v1.2.5',
'v1.3.0'
],
timestamp: {
created: 1_541_458_026,
closed: 1_541_457_010
}
}
},
{
index: {}
},
{
title: 'Somewhat less urgent',
labels: {
priority: 'high',
release: [
'v1.3.0'
],
timestamp: {
created: 1_541_458_026,
closed: 1_541_457_010
}
}
},
{
index: {}
},
{
title: 'Not urgent',
labels: {
priority: 'low',
release: [
'v1.2.0'
],
timestamp: {
created: 1_541_458_026,
closed: 1_541_457_010
}
}
}
]
)
puts response
const response = await client.bulk({
index: "my-index-000001",
refresh: "true",
operations: [
{
index: {},
},
{
title: "Something really urgent",
labels: {
priority: "urgent",
release: ["v1.2.5", "v1.3.0"],
timestamp: {
created: 1541458026,
closed: 1541457010,
},
},
},
{
index: {},
},
{
title: "Somewhat less urgent",
labels: {
priority: "high",
release: ["v1.3.0"],
timestamp: {
created: 1541458026,
closed: 1541457010,
},
},
},
{
index: {},
},
{
title: "Not urgent",
labels: {
priority: "low",
release: ["v1.2.0"],
timestamp: {
created: 1541458026,
closed: 1541457010,
},
},
},
],
});
console.log(response);
POST /my-index-000001/_bulk?refresh
{"index":{}}
{"title":"Something really urgent","labels":{"priority":"urgent","release":["v1.2.5","v1.3.0"],"timestamp":{"created":1541458026,"closed":1541457010}}}
{"index":{}}
{"title":"Somewhat less urgent","labels":{"priority":"high","release":["v1.3.0"],"timestamp":{"created":1541458026,"closed":1541457010}}}
{"index":{}}
{"title":"Not urgent","labels":{"priority":"low","release":["v1.2.0"],"timestamp":{"created":1541458026,"closed":1541457010}}}
Because labels
is a flattened
field type, the entire object is mapped as a single field. To retrieve values from this sub-field in a Painless script, use the doc['<field_name>.<sub-field_name>'].value
format.
"script": {
"source": """
if (doc['labels.release'].value.equals('v1.3.0'))
{emit(doc['labels.release'].value)}
else{emit('Version mismatch')}
"""
Parameters for flattened object fields
The following mapping parameters are accepted:
| The maximum allowed depth of the flattened object field, in terms of nested inner objects. If a flattened object field exceeds this limit, then an error will be thrown. Defaults to |
Should the field be stored on disk in a column-stride fashion, so that it can later be used for sorting, aggregations, or scripting? Accepts | |
Should global ordinals be loaded eagerly on refresh? Accepts | |
Leaf values longer than this limit will not be indexed. By default, there is no limit and all values will be indexed. Note that this limit applies to the leaf values within the flattened object field, and not the length of the entire field. | |
Determines if the field should be searchable. Accepts | |
What information should be stored in the index for scoring purposes. Defaults to | |
A string value which is substituted for any explicit | |
Which scoring algorithm or similarity should be used. Defaults to | |
| Whether full text queries should split the input on whitespace when building a query for this field. Accepts |
| (Optional, array of strings) A list of fields inside the flattened object, where each field is a dimension of the time series. Each field is specified using the relative path from the root field and does not include the root field name. |
Synthetic _source
Synthetic _source
is Generally Available only for TSDB indices (indices that have index.mode
set to time_series
). For other indices synthetic _source
is in technical preview. Features in technical preview may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features.
Flattened fields support synthetic`_source` in their default configuration.
Synthetic source may sort flattened
field values and remove duplicates. For example:
resp = client.indices.create(
index="idx",
settings={
"index": {
"mapping": {
"source": {
"mode": "synthetic"
}
}
}
},
mappings={
"properties": {
"flattened": {
"type": "flattened"
}
}
},
)
print(resp)
resp1 = client.index(
index="idx",
id="1",
document={
"flattened": {
"field": [
"apple",
"apple",
"banana",
"avocado",
"10",
"200",
"AVOCADO",
"Banana",
"Tangerine"
]
}
},
)
print(resp1)
const response = await client.indices.create({
index: "idx",
settings: {
index: {
mapping: {
source: {
mode: "synthetic",
},
},
},
},
mappings: {
properties: {
flattened: {
type: "flattened",
},
},
},
});
console.log(response);
const response1 = await client.index({
index: "idx",
id: 1,
document: {
flattened: {
field: [
"apple",
"apple",
"banana",
"avocado",
"10",
"200",
"AVOCADO",
"Banana",
"Tangerine",
],
},
},
});
console.log(response1);
PUT idx
{
"settings": {
"index": {
"mapping": {
"source": {
"mode": "synthetic"
}
}
}
},
"mappings": {
"properties": {
"flattened": { "type": "flattened" }
}
}
}
PUT idx/_doc/1
{
"flattened": {
"field": [ "apple", "apple", "banana", "avocado", "10", "200", "AVOCADO", "Banana", "Tangerine" ]
}
}
Will become:
{
"flattened": {
"field": [ "10", "200", "AVOCADO", "Banana", "Tangerine", "apple", "avocado", "banana" ]
}
}
Synthetic source always uses nested objects instead of array of objects. For example:
resp = client.indices.create(
index="idx",
settings={
"index": {
"mapping": {
"source": {
"mode": "synthetic"
}
}
}
},
mappings={
"properties": {
"flattened": {
"type": "flattened"
}
}
},
)
print(resp)
resp1 = client.index(
index="idx",
id="1",
document={
"flattened": {
"field": [
{
"id": 1,
"name": "foo"
},
{
"id": 2,
"name": "bar"
},
{
"id": 3,
"name": "baz"
}
]
}
},
)
print(resp1)
const response = await client.indices.create({
index: "idx",
settings: {
index: {
mapping: {
source: {
mode: "synthetic",
},
},
},
},
mappings: {
properties: {
flattened: {
type: "flattened",
},
},
},
});
console.log(response);
const response1 = await client.index({
index: "idx",
id: 1,
document: {
flattened: {
field: [
{
id: 1,
name: "foo",
},
{
id: 2,
name: "bar",
},
{
id: 3,
name: "baz",
},
],
},
},
});
console.log(response1);
PUT idx
{
"settings": {
"index": {
"mapping": {
"source": {
"mode": "synthetic"
}
}
}
},
"mappings": {
"properties": {
"flattened": { "type": "flattened" }
}
}
}
PUT idx/_doc/1
{
"flattened": {
"field": [
{ "id": 1, "name": "foo" },
{ "id": 2, "name": "bar" },
{ "id": 3, "name": "baz" }
]
}
}
Will become (note the nested objects instead of the “flattened” array):
{
"flattened": {
"field": {
"id": [ "1", "2", "3" ],
"name": [ "bar", "baz", "foo" ]
}
}
}
Synthetic source always uses single-valued fields for one-element arrays. For example:
resp = client.indices.create(
index="idx",
settings={
"index": {
"mapping": {
"source": {
"mode": "synthetic"
}
}
}
},
mappings={
"properties": {
"flattened": {
"type": "flattened"
}
}
},
)
print(resp)
resp1 = client.index(
index="idx",
id="1",
document={
"flattened": {
"field": [
"foo"
]
}
},
)
print(resp1)
const response = await client.indices.create({
index: "idx",
settings: {
index: {
mapping: {
source: {
mode: "synthetic",
},
},
},
},
mappings: {
properties: {
flattened: {
type: "flattened",
},
},
},
});
console.log(response);
const response1 = await client.index({
index: "idx",
id: 1,
document: {
flattened: {
field: ["foo"],
},
},
});
console.log(response1);
PUT idx
{
"settings": {
"index": {
"mapping": {
"source": {
"mode": "synthetic"
}
}
}
},
"mappings": {
"properties": {
"flattened": { "type": "flattened" }
}
}
}
PUT idx/_doc/1
{
"flattened": {
"field": [ "foo" ]
}
}
Will become (note the nested objects instead of the “flattened” array):
{
"flattened": {
"field": "foo"
}
}