Any chances that CrateDB will support _all fields like ES does right now?

CrateDB
#1

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

#2

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
#3

Thanks @mfussenegger :slightly_smiling_face:

#4

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:

  1. Any alternative solution for adding ‘new_column’ in ‘title_body_ft’ without creating the table again?
  2. How to avoid re-indexing here?

@mfussenegger any help would be much appreciated?