Skip to content

SQL: Deprecation warning when querying a frozen index or listing frozen indices #81939

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
Closed
Luegg opened this issue Dec 20, 2021 · 1 comment · Fixed by #83943
Closed

SQL: Deprecation warning when querying a frozen index or listing frozen indices #81939

Luegg opened this issue Dec 20, 2021 · 1 comment · Fixed by #83943
Labels
:Analytics/SQL SQL querying >deprecation Team:QL (Deprecated) Meta label for query languages team

Comments

@Luegg
Copy link
Contributor

Luegg commented Dec 20, 2021

Frozen indices are deprecated which makes all the SQL features supporting frozen indices obsolete.

This includes:

  • index_include_frozen request parameter in the _sql endpoint
  • index.include.frozen (J|O)DBC driver settings
  • SHOW TABLES INCLUDE FROZEN queries and the FROZEN INDEX kind in the corresponding response
  • The FROZEN modifier in FROM clauses (as in SELECT * FROM FROZEN archive)

_search raises a deprecation warning when frozen indices are being searched with ignore_throttled=false. SQL could do the same when the index_include_frozen request parameter is set or when the FROZEN keyword is used.

Relates to #70192
@elasticmachine elasticmachine added the Team:QL (Deprecated) Meta label for query languages team label Dec 20, 2021
@elasticmachine
Copy link
Collaborator

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

@Luegg Luegg mentioned this issue Dec 20, 2021
Open
12 tasks
@Luegg Luegg mentioned this issue Feb 15, 2022
Merged
elasticsearchmachine pushed a commit that referenced this issue Feb 23, 2022
SQL: Deprecate index_include_frozen request parameter and FROZEN ke…
7900a0b 
…yword (#83943)

Resolves #81939 (part of
#70192)

Deprecates the `index_include_frozen` REST parameter in the `/_sql`
endpoint and all the syntax including the `FROZEN` keyword.
Luegg pushed a commit to Luegg/elasticsearch that referenced this issue Feb 23, 2022
SQL: Deprecate index_include_frozen request parameter and FROZEN ke…
2137711 
…yword (elastic#83943)

Resolves elastic#81939 (part of
elastic#70192)

Deprecates the `index_include_frozen` REST parameter in the `/_sql`
endpoint and all the syntax including the `FROZEN` keyword.
# Conflicts:
#	x-pack/plugin/sql/src/main/java/org/elasticsearch/xpack/sql/parser/LogicalPlanBuilder.java
elasticsearchmachine pushed a commit that referenced this issue Feb 23, 2022
SQL: Deprecate index_include_frozen request parameter and FROZEN ke…
cabb749 
…yword (#83943) (#84298)

Resolves #81939 (part of
#70192)

Deprecates the `index_include_frozen` REST parameter in the `/_sql`
endpoint and all the syntax including the `FROZEN` keyword.
# Conflicts:
#	x-pack/plugin/sql/src/main/java/org/elasticsearch/xpack/sql/parser/LogicalPlanBuilder.java
probakowski pushed a commit to probakowski/elasticsearch that referenced this issue Feb 23, 2022
@probakowski
SQL: Deprecate index_include_frozen request parameter and FROZEN ke…
23b85ed 
…yword (elastic#83943)

Resolves elastic#81939 (part of
elastic#70192)

Deprecates the `index_include_frozen` REST parameter in the `/_sql`
endpoint and all the syntax including the `FROZEN` keyword.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
:Analytics/SQL SQL querying >deprecation Team:QL (Deprecated) Meta label for query languages team
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

SQL: Deprecate index_include_frozen request parameter and FROZEN keyword Luegg/elasticsearch
2 participants
@Luegg @elasticmachine