Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL: Support Frozen indices #39390

Closed
costin opened this issue Feb 26, 2019 · 2 comments · Fixed by #41558
Closed

SQL: Support Frozen indices #39390

costin opened this issue Feb 26, 2019 · 2 comments · Fixed by #41558
Assignees
@costin
Labels
:Analytics/SQL SQL querying >feature v7.3.0 v8.0.0-alpha1

Comments

@costin
Copy link
Member

costin commented Feb 26, 2019

Introduced in 6.6, frozen indices support searches within certain constraints.
SQL should be able to detect them and run queries around them. Even better, it should chose the correct search options (such as pre_filter_shard_size).

Related to #39377
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search

@costin costin mentioned this issue Feb 26, 2019
Closed
@astefan
Copy link
Contributor

astefan commented Feb 26, 2019

I would be in favor of giving the user the option (or explicit consent) that they want to search such an index. Just like ES itself "asks" for such a special consent through ignore_throttled parameter. And this should apply for searches over wildcard named indices as well.

@costin costin self-assigned this Apr 23, 2019
costin added a commit to costin/elasticsearch that referenced this issue Apr 25, 2019
@costin
SQL: Add support for FROZEN indices
b6a63ea 
Allow querying of FROZEN indices both through dedicated SQL grammar
extension:
> SELECT field FROM FROZEN index
and also through driver configuration parameter, namely:
> index.include.frozen: true/false

Fix elastic#39390
Fix elastic#39377
@costin costin mentioned this issue Apr 25, 2019
Merged
costin added a commit that referenced this issue May 9, 2019
@costin
SQL: Add support for FROZEN indices (#41558)
2445a93 
Allow querying of FROZEN indices both through dedicated SQL grammar
extension:
> SELECT field FROM FROZEN index
and also through driver configuration parameter, namely:
> index.include.frozen: true/false

Fix #39390
Fix #39377
costin added a commit that referenced this issue May 23, 2019
@costin
SQL: Add support for FROZEN indices (#41558)
d5f04d2 
Allow querying of FROZEN indices both through dedicated SQL grammar
extension:
> SELECT field FROM FROZEN index
and also through driver configuration parameter, namely:
> index.include.frozen: true/false

Fix #39390
Fix #39377

(cherry picked from commit 2445a93)
matriv pushed a commit to matriv/elasticsearch that referenced this issue May 24, 2019
@costin @matriv
SQL: Add support for FROZEN indices (elastic#41558)
065b6d5 
Allow querying of FROZEN indices both through dedicated SQL grammar
extension:
> SELECT field FROM FROZEN index
and also through driver configuration parameter, namely:
> index.include.frozen: true/false

Fix elastic#39390
Fix elastic#39377

(cherry picked from commit 2445a93)
gurkankaymak pushed a commit to gurkankaymak/elasticsearch that referenced this issue May 27, 2019
@costin
SQL: Add support for FROZEN indices (elastic#41558)
8e647f3 
Allow querying of FROZEN indices both through dedicated SQL grammar
extension:
> SELECT field FROM FROZEN index
and also through driver configuration parameter, namely:
> index.include.frozen: true/false

Fix elastic#39390
Fix elastic#39377
@colings86 colings86 added v7.3.0 and removed v7.2.0 labels Jun 10, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@costin costin

Labels
:Analytics/SQL SQL querying >feature v7.3.0 v8.0.0-alpha1
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

SQL: Add support for FROZEN indices costin/elasticsearch
5 participants
@costin @colings86 @astefan @jakelandis @elasticmachine