search

elastic / elasticsearch

Free and Open Source, Distributed, RESTful Search Engine
https://www.elastic.co/products/elasticsearch
Other
1.5k stars 24.89k forks source link

SQL: allow SELECTing with qualified wildcard #50293

Open bpintea opened 4 years ago

bpintea commented 4 years ago

Current parser allows qualifying a (potentially) nested field with table's name:

SELECT kibana_sample_data_ecommerce.products.price FROM kibana_sample_data_ecommerce

However, selecting all table's columns won't work: the following query

SELECT kibana_sample_data_ecommerce.* FROM kibana_sample_data_ecommerce

is rejected with a verification_exception: Found 1 problem(s)\nline 1:9: Unknown column [kibana_sample_data_ecommerce].

This FR is about extending the grammar to allow this syntax; some BI tools - like Tibco Spotfire - make use of it.

elasticmachine commented 4 years ago

Pinging @elastic/es-search (:Search/SQL)

GustBM commented 4 years ago

If the issue is still on i'd like to give it a try

matriv commented 4 years ago

Hi. Thank you for your interest in contributing! Inline with common open source practices, we would like to no longer block and attribute issues, but rather invite anyone with a concrete proposal to simply submit a PR. No one likes duplicating work, but please consider that chances of concurrent PRs are low - especially for longer standing issues - and quality will trump over submission order.

elasticsearchmachine commented 10 months ago

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