In ES:
The copy_to
parameter allows you to create custom _all
fields. In other words, the values of multiple fields can be copied into a group field, which can then be queried as a single field.
Right now CrateDB does not support having such a dynamic column based on a combination of other columns. Do we have such a feature in pipeline?
https://www.elastic.co/guide/en/elasticsearch/reference/current/copy-to.html
Given that _all
is deprecated in ES it is very unlikely that we’ll add support for it.
CrateDB exposes something similar to copy-to
with composite indices.
1 Like
This is our table initially;
create table documents_a (
... title text,
... body text,
... INDEX title_body_ft
... using fulltext(title, body) with (analyzer = 'english')
... )
Now suppose we need to add a column (new_column) in ‘documents_a’ for that we need to create our table again and re-index data.
create table documents_a (
... title text,
... body text,
... new_column text,
... INDEX title_body_ft
... using fulltext(title, body,new_column) with (analyzer = 'english')
... )
Now my questions are:
- Any alternative solution for adding ‘new_column’ in ‘title_body_ft’ without creating the table again?
- How to avoid re-indexing here?
@mfussenegger any help would be much appreciated?