[ES|QL] Be able to use "*" in WHERE to select all fields

elastic / elasticsearch

Free and Open, Distributed, RESTful Search Engine

https://www.elastic.co/products/elasticsearch

Other

69.5k stars 24.6k forks source link

[ES|QL] Be able to use "*" in WHERE to select all fields #103578

Open ninoslavmiskovic opened 8 months ago

ninoslavmiskovic commented 8 months ago

Description

As a user I want to be able to use "*" in WHERE.

This has been requested by users. E.g. to search for a keyword let's say "U.S" in all the fields from an index

An example of a potential query:

from kibana_sample_data_logs
| where * rlike "US"
| keep message, geo.dest, agent

We can use "*" with FROM, so why not allow it for WHERE :)

elasticsearchmachine commented 8 months ago

Pinging @elastic/es-ql (Team:QL)

elasticsearchmachine commented 8 months ago

Pinging @elastic/elasticsearch-esql (:Query Languages/ES|QL)

elasticsearchmachine commented 8 months ago

Pinging @elastic/es-analytics-geo (Team:Analytics)

costin commented 7 months ago

This is a full-text feature namely to find columns matching a certain value. It's best to address this as part of said functionality which will introduce a dedicated command with its own semantics, similar but different than where

elasticsearchmachine commented 4 months ago

Pinging @elastic/es-analytical-engine (Team:Analytics)