Skip to content
BranchesTags

Latest commit

History

2,373 Commits

Folders and files

NameName
Last commit message
Last commit date
.claude
.claude
.github
.github
api
api
async-query-core
async-query-core
async-query
async-query
benchmarks
benchmarks
build-tools
build-tools
buildSrc
buildSrc
common
common
core
core
datasources
datasources
direct-query-core
direct-query-core
direct-query
direct-query
docs
docs
doctest
doctest
gradle/wrapper
gradle/wrapper
integ-test
integ-test
language-grammar
language-grammar
legacy
legacy
opensearch
opensearch
plugin
plugin
ppl-rest-spi
ppl-rest-spi
ppl
ppl
prometheus
prometheus
protocol
protocol
release-notes
release-notes
scripts
scripts
spark
spark
sql
sql
.codecov.yml
.codecov.yml
.gitignore
.gitignore
.lycheeignore
.lycheeignore
.pre-commit-config.yaml
.pre-commit-config.yaml
.whitesource
.whitesource
ADMINS.md
ADMINS.md
CLAUDE.md
CLAUDE.md
CLAUDE_GUIDE.md
CLAUDE_GUIDE.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
CONTRIBUTORS.md
CONTRIBUTORS.md
DEVELOPER_GUIDE.rst
DEVELOPER_GUIDE.rst
LICENSE.txt
LICENSE.txt
MAINTAINERS.md
MAINTAINERS.md
NOTICE
NOTICE
README.md
README.md
RELEASING.md
RELEASING.md
SECURITY.md
SECURITY.md
THIRD-PARTY
THIRD-PARTY
build.gradle
build.gradle
gradle.properties
gradle.properties
gradlew
gradlew
gradlew.bat
gradlew.bat
lombok.config
lombok.config
settings.gradle
settings.gradle

Repository files navigation

OpenSearch SQL

OpenSearch enables you to extract insights out of OpenSearch using the familiar SQL or Piped Processing Language (PPL) query syntax. Use aggregations, group by, and where clauses to investigate your data. Read your data as JSON documents or CSV tables so you have the flexibility to use the format that works best for you.

The following projects are related to the SQL plugin, but stored in the different repos. Please refer to links below for details. This document will focus on the SQL plugin for OpenSearch.

Code Summary

SQL Engine

Test and build[![SQL CI][sql-ci-badge]][sql-ci-link]
Code coveragecodecov
Distribution build testsOpenSearch IT testsOpenSearch IT code
Backward compatibility testsBWC tests

Repository Checks

DCO Checker[![Developer certificate of origin][dco-badge]][dco-badge-link]
Link CheckerLink Checker

Issues

good first issues open
features open
enhancements open
bugs open
untriaged open
nolabel open

Highlights

Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualization. Please check our documentation for more details.

Recently we have been actively improving our query engine primarily for better correctness and extensibility. Behind the scene, the new enhanced engine has already supported both SQL and Piped Processing Language. Please find more details in SQL Engine V2 - Release Notes.

Documentation

Please refer to the SQL Language Reference Manual, Piped Processing Language (PPL) Reference Manual, OpenSearch SQL/PPL Engine Development Manual and Technical Documentation for detailed information on installing and configuring plugin.

Forum

For additional help with the plugin, including questions about opening an issue, visit the OpenSearch Forum.

Contributing

See developer guide and how to contribute to this project.

Attribution

This project is based on the Apache 2.0-licensed elasticsearch-sql project. Thank you eliranmoyal, shi-yuan, ansjsun and everyone else who contributed great code to that project. Read this for more details Attributions.

Code of Conduct

This project has adopted an Open Source Code of Conduct.

Security

If you discover a potential security issue in this project we ask that you notify OpenSearch Security directly via email to security@opensearch.org. Please do not create a public GitHub issue.

License

See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.

Copyright

Copyright OpenSearch Contributors. See NOTICE for details.

About

Query your data using familiar SQL or intuitive Piped Processing Language (PPL)

opensearch.org/docs/latest/search-plugins/sql/index/

Resources

Readme
License

Code of conduct

Code of conduct

Contributing

Contributing

Security policy

Security policy
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

Packages

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { // Add copy buttons to all 
 blocks
(function() {
function addCopyButtons() {
document.querySelectorAll('pre code').forEach(function(codeBlock) {
if (codeBlock.parentElement.hasAttribute('data-copy-added')) return;
codeBlock.parentElement.setAttribute('data-copy-added', 'true');
var btn = document.createElement('button');
btn.textContent = 'Copy';
btn.style.cssText = 'position:absolute;top:4px;right:4px;padding:2px 8px;font-size:11px;background:#4ecdc4;border:none;border-radius:4px;color:#1a1a2e;cursor:pointer;opacity:0.7;transition:opacity 0.2s;';
btn.onmouseover = function() { this.style.opacity = '1'; };
btn.onmouseout = function() { this.style.opacity = '0.7'; };
btn.onclick = function() {
navigator.clipboard.writeText(codeBlock.textContent).then(function() {
btn.textContent = 'Copied!';
setTimeout(function() { btn.textContent = 'Copy'; }, 1500);
});
};
codeBlock.parentElement.style.position = 'relative';
codeBlock.parentElement.appendChild(btn);
});
}
addCopyButtons();
// Re-run on dynamic content
var observer = new MutationObserver(addCopyButtons);
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Add Copy Buttons to Code Blocks]', __e); }
})();
(function(){
try {
var __m = "github.com";
var __re = new RegExp('^' + "github\\.com" + '
GitHub - RyanL1997/sql: Query your data using familiar SQL or intuitive Piped Processing Language (PPL) · GitHub
Skip to content
BranchesTags
Latest commit
History
2,373 Commits
Folders and files
NameName
Last commit message
Last commit date
.claude
.claude
.github
.github
api
api
async-query-core
async-query-core
async-query
async-query
benchmarks
benchmarks
build-tools
build-tools
buildSrc
buildSrc
common
common
core
core
datasources
datasources
direct-query-core
direct-query-core
direct-query
direct-query
docs
docs
doctest
doctest
gradle/wrapper
gradle/wrapper
integ-test
integ-test
language-grammar
language-grammar
legacy
legacy
opensearch
opensearch
plugin
plugin
ppl-rest-spi
ppl-rest-spi
ppl
ppl
prometheus
prometheus
protocol
protocol
release-notes
release-notes
scripts
scripts
spark
spark
sql
sql
.codecov.yml
.codecov.yml
.gitignore
.gitignore
.lycheeignore
.lycheeignore
.pre-commit-config.yaml
.pre-commit-config.yaml
.whitesource
.whitesource
ADMINS.md
ADMINS.md
CLAUDE.md
CLAUDE.md
CLAUDE_GUIDE.md
CLAUDE_GUIDE.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
CONTRIBUTORS.md
CONTRIBUTORS.md
DEVELOPER_GUIDE.rst
DEVELOPER_GUIDE.rst
LICENSE.txt
LICENSE.txt
MAINTAINERS.md
MAINTAINERS.md
NOTICE
NOTICE
README.md
README.md
RELEASING.md
RELEASING.md
SECURITY.md
SECURITY.md
THIRD-PARTY
THIRD-PARTY
build.gradle
build.gradle
gradle.properties
gradle.properties
gradlew
gradlew
gradlew.bat
gradlew.bat
lombok.config
lombok.config
settings.gradle
settings.gradle
Repository files navigation
OpenSearch SQL
OpenSearch enables you to extract insights out of OpenSearch using the familiar SQL or Piped Processing Language (PPL) query syntax. Use aggregations, group by, and where clauses to investigate your data. Read your data as JSON documents or CSV tables so you have the flexibility to use the format that works best for you.
The following projects are related to the SQL plugin, but stored in the different repos. Please refer to links below for details. This document will focus on the SQL plugin for OpenSearch.
Code Summary
SQL Engine
Test and build[![SQL CI][sql-ci-badge]][sql-ci-link]
Code coveragecodecov
Distribution build testsOpenSearch IT testsOpenSearch IT code
Backward compatibility testsBWC tests
Repository Checks
DCO Checker[![Developer certificate of origin][dco-badge]][dco-badge-link]
Link CheckerLink Checker
Issues
good first issues open
features open
enhancements open
bugs open
untriaged open
nolabel open
Highlights
Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualization. Please check our documentation for more details.
Recently we have been actively improving our query engine primarily for better correctness and extensibility. Behind the scene, the new enhanced engine has already supported both SQL and Piped Processing Language. Please find more details in SQL Engine V2 - Release Notes.
Documentation
Please refer to the SQL Language Reference Manual, Piped Processing Language (PPL) Reference Manual, OpenSearch SQL/PPL Engine Development Manual and Technical Documentation for detailed information on installing and configuring plugin.
Forum
For additional help with the plugin, including questions about opening an issue, visit the OpenSearch Forum.
Contributing
See developer guide and how to contribute to this project.
Attribution
This project is based on the Apache 2.0-licensed elasticsearch-sql project. Thank you eliranmoyal, shi-yuan, ansjsun and everyone else who contributed great code to that project. Read this for more details Attributions.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security
If you discover a potential security issue in this project we ask that you notify OpenSearch Security directly via email to security@opensearch.org. Please do not create a public GitHub issue.
License
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright OpenSearch Contributors. See NOTICE for details.
About
Query your data using familiar SQL or intuitive Piped Processing Language (PPL)
opensearch.org/docs/latest/search-plugins/sql/index/
Resources
Readme
License
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Stars
0 stars
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Force GitHub README to respect dark mode
(function() {
var style = document.createElement('style');
style.textContent = '
.markdown-body {
color-scheme: dark light;
}
.markdown-body pre { background: #161b22 !important; }
.markdown-body code { background: rgba(110, 118, 129, 0.4) !important; }
.markdown-body table th, .markdown-body table td { border-color: #30363d !important; }
.markdown-body img { background: #0d1117; }
.markdown-body blockquote { border-left-color: #8b949e; }
.markdown-body hr { border-color: #30363d; }
';
document.head.appendChild(style);
})();
}
} catch(__e) { console.warn('[Userscript:GitHub Dark Mode README Fix]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
GitHub - RyanL1997/sql: Query your data using familiar SQL or intuitive Piped Processing Language (PPL) · GitHub
Skip to content
BranchesTags
Latest commit
History
2,373 Commits
Folders and files
NameName
Last commit message
Last commit date
.claude
.claude
.github
.github
api
api
async-query-core
async-query-core
async-query
async-query
benchmarks
benchmarks
build-tools
build-tools
buildSrc
buildSrc
common
common
core
core
datasources
datasources
direct-query-core
direct-query-core
direct-query
direct-query
docs
docs
doctest
doctest
gradle/wrapper
gradle/wrapper
integ-test
integ-test
language-grammar
language-grammar
legacy
legacy
opensearch
opensearch
plugin
plugin
ppl-rest-spi
ppl-rest-spi
ppl
ppl
prometheus
prometheus
protocol
protocol
release-notes
release-notes
scripts
scripts
spark
spark
sql
sql
.codecov.yml
.codecov.yml
.gitignore
.gitignore
.lycheeignore
.lycheeignore
.pre-commit-config.yaml
.pre-commit-config.yaml
.whitesource
.whitesource
ADMINS.md
ADMINS.md
CLAUDE.md
CLAUDE.md
CLAUDE_GUIDE.md
CLAUDE_GUIDE.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
CONTRIBUTORS.md
CONTRIBUTORS.md
DEVELOPER_GUIDE.rst
DEVELOPER_GUIDE.rst
LICENSE.txt
LICENSE.txt
MAINTAINERS.md
MAINTAINERS.md
NOTICE
NOTICE
README.md
README.md
RELEASING.md
RELEASING.md
SECURITY.md
SECURITY.md
THIRD-PARTY
THIRD-PARTY
build.gradle
build.gradle
gradle.properties
gradle.properties
gradlew
gradlew
gradlew.bat
gradlew.bat
lombok.config
lombok.config
settings.gradle
settings.gradle
Repository files navigation
OpenSearch SQL
OpenSearch enables you to extract insights out of OpenSearch using the familiar SQL or Piped Processing Language (PPL) query syntax. Use aggregations, group by, and where clauses to investigate your data. Read your data as JSON documents or CSV tables so you have the flexibility to use the format that works best for you.
The following projects are related to the SQL plugin, but stored in the different repos. Please refer to links below for details. This document will focus on the SQL plugin for OpenSearch.
Code Summary
SQL Engine
Test and build[![SQL CI][sql-ci-badge]][sql-ci-link]
Code coveragecodecov
Distribution build testsOpenSearch IT testsOpenSearch IT code
Backward compatibility testsBWC tests
Repository Checks
DCO Checker[![Developer certificate of origin][dco-badge]][dco-badge-link]
Link CheckerLink Checker
Issues
good first issues open
features open
enhancements open
bugs open
untriaged open
nolabel open
Highlights
Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualization. Please check our documentation for more details.
Recently we have been actively improving our query engine primarily for better correctness and extensibility. Behind the scene, the new enhanced engine has already supported both SQL and Piped Processing Language. Please find more details in SQL Engine V2 - Release Notes.
Documentation
Please refer to the SQL Language Reference Manual, Piped Processing Language (PPL) Reference Manual, OpenSearch SQL/PPL Engine Development Manual and Technical Documentation for detailed information on installing and configuring plugin.
Forum
For additional help with the plugin, including questions about opening an issue, visit the OpenSearch Forum.
Contributing
See developer guide and how to contribute to this project.
Attribution
This project is based on the Apache 2.0-licensed elasticsearch-sql project. Thank you eliranmoyal, shi-yuan, ansjsun and everyone else who contributed great code to that project. Read this for more details Attributions.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security
If you discover a potential security issue in this project we ask that you notify OpenSearch Security directly via email to security@opensearch.org. Please do not create a public GitHub issue.
License
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright OpenSearch Contributors. See NOTICE for details.
About
Query your data using familiar SQL or intuitive Piped Processing Language (PPL)
opensearch.org/docs/latest/search-plugins/sql/index/
Resources
Readme
License
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Stars
0 stars
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Highlight search terms from Google/DuckDuckGo/Bing referrer
(function() {
var ref = document.referrer;
var terms = [];
if (ref.includes('google.com') || ref.includes('duckduckgo.com') || ref.includes('bing.com')) {
var url = new URL(ref);
var q = url.searchParams.get('q') || url.searchParams.get('p');
if (q) {
terms = q.split(/\s+/).filter(function(t) { return t.length > 2; });
}
}
if (terms.length === 0) return;
var style = document.createElement('style');
style.textContent = '.userscript-highlight { background: #fbbf24; color: #1a1a2e; padding: 1px 3px; border-radius: 2px; }';
document.head.appendChild(style);
function highlight(node) {
if (node.nodeType === 3) { // text node
var text = node.textContent;
var found = false;
terms.forEach(function(term) {
var regex = new RegExp('(' + term.replace(/[.*+?^${}()|[\]\\]/g, '\\') + ')', 'gi');
if (regex.test(text)) {
found = true;
var frag = document.createDocumentFragment();
var parts = text.split(regex);
parts.forEach(function(part, i) {
if (i % 2 === 0) {
frag.appendChild(document.createTextNode(part));
} else {
var span = document.createElement('span');
span.className = 'userscript-highlight';
span.textContent = part;
frag.appendChild(span);
}
});
node.parentNode.replaceChild(frag, node);
}
});
} else if (node.nodeType === 1 && node.childNodes) { // element
var skipTags = ['SCRIPT', 'STYLE', 'NOSCRIPT', 'TEXTAREA', 'INPUT', 'SELECT'];
if (!skipTags.includes(node.tagName)) {
Array.from(node.childNodes).forEach(highlight);
}
}
}
highlight(document.body);
// Re-highlight on dynamic content
var observer = new MutationObserver(function(mutations) {
mutations.forEach(function(m) {
m.addedNodes.forEach(function(node) {
if (node.nodeType === 1 || node.nodeType === 3) highlight(node);
});
});
});
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Highlight Search Terms]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
GitHub - RyanL1997/sql: Query your data using familiar SQL or intuitive Piped Processing Language (PPL) · GitHub
Skip to content
BranchesTags
Latest commit
History
2,373 Commits
Folders and files
NameName
Last commit message
Last commit date
.claude
.claude
.github
.github
api
api
async-query-core
async-query-core
async-query
async-query
benchmarks
benchmarks
build-tools
build-tools
buildSrc
buildSrc
common
common
core
core
datasources
datasources
direct-query-core
direct-query-core
direct-query
direct-query
docs
docs
doctest
doctest
gradle/wrapper
gradle/wrapper
integ-test
integ-test
language-grammar
language-grammar
legacy
legacy
opensearch
opensearch
plugin
plugin
ppl-rest-spi
ppl-rest-spi
ppl
ppl
prometheus
prometheus
protocol
protocol
release-notes
release-notes
scripts
scripts
spark
spark
sql
sql
.codecov.yml
.codecov.yml
.gitignore
.gitignore
.lycheeignore
.lycheeignore
.pre-commit-config.yaml
.pre-commit-config.yaml
.whitesource
.whitesource
ADMINS.md
ADMINS.md
CLAUDE.md
CLAUDE.md
CLAUDE_GUIDE.md
CLAUDE_GUIDE.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
CONTRIBUTORS.md
CONTRIBUTORS.md
DEVELOPER_GUIDE.rst
DEVELOPER_GUIDE.rst
LICENSE.txt
LICENSE.txt
MAINTAINERS.md
MAINTAINERS.md
NOTICE
NOTICE
README.md
README.md
RELEASING.md
RELEASING.md
SECURITY.md
SECURITY.md
THIRD-PARTY
THIRD-PARTY
build.gradle
build.gradle
gradle.properties
gradle.properties
gradlew
gradlew
gradlew.bat
gradlew.bat
lombok.config
lombok.config
settings.gradle
settings.gradle
Repository files navigation
OpenSearch SQL
OpenSearch enables you to extract insights out of OpenSearch using the familiar SQL or Piped Processing Language (PPL) query syntax. Use aggregations, group by, and where clauses to investigate your data. Read your data as JSON documents or CSV tables so you have the flexibility to use the format that works best for you.
The following projects are related to the SQL plugin, but stored in the different repos. Please refer to links below for details. This document will focus on the SQL plugin for OpenSearch.
Code Summary
SQL Engine
Test and build[![SQL CI][sql-ci-badge]][sql-ci-link]
Code coveragecodecov
Distribution build testsOpenSearch IT testsOpenSearch IT code
Backward compatibility testsBWC tests
Repository Checks
DCO Checker[![Developer certificate of origin][dco-badge]][dco-badge-link]
Link CheckerLink Checker
Issues
good first issues open
features open
enhancements open
bugs open
untriaged open
nolabel open
Highlights
Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualization. Please check our documentation for more details.
Recently we have been actively improving our query engine primarily for better correctness and extensibility. Behind the scene, the new enhanced engine has already supported both SQL and Piped Processing Language. Please find more details in SQL Engine V2 - Release Notes.
Documentation
Please refer to the SQL Language Reference Manual, Piped Processing Language (PPL) Reference Manual, OpenSearch SQL/PPL Engine Development Manual and Technical Documentation for detailed information on installing and configuring plugin.
Forum
For additional help with the plugin, including questions about opening an issue, visit the OpenSearch Forum.
Contributing
See developer guide and how to contribute to this project.
Attribution
This project is based on the Apache 2.0-licensed elasticsearch-sql project. Thank you eliranmoyal, shi-yuan, ansjsun and everyone else who contributed great code to that project. Read this for more details Attributions.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security
If you discover a potential security issue in this project we ask that you notify OpenSearch Security directly via email to security@opensearch.org. Please do not create a public GitHub issue.
License
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright OpenSearch Contributors. See NOTICE for details.
About
Query your data using familiar SQL or intuitive Piped Processing Language (PPL)
opensearch.org/docs/latest/search-plugins/sql/index/
Resources
Readme
License
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Stars
0 stars
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Strip utm_, fbclid, gclid, etc. from all links on page
(function() {
var trackingParams = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content',
'fbclid', 'gclid', 'dclid', 'msclkid', 'yclid',
'ref', 'ref_src', 'source', 'medium', 'campaign'];
function cleanUrl(url) {
try {
var u = new URL(url, window.location.origin);
var changed = false;
trackingParams.forEach(function(p) {
if (u.searchParams.has(p)) {
u.searchParams.delete(p);
changed = true;
}
});
return changed ? u.toString() : url;
} catch (e) {
return url;
}
}
function cleanLinks() {
document.querySelectorAll('a[href]').forEach(function(a) {
var clean = cleanUrl(a.href);
if (clean !== a.href) a.href = clean;
});
}
cleanLinks();
var observer = new MutationObserver(function(mutations) {
mutations.forEach(function(m) {
m.addedNodes.forEach(function(node) {
if (node.nodeType === 1) {
if (node.tagName === 'A') cleanLinks();
node.querySelectorAll('a[href]').forEach(function(a) {
var clean = cleanUrl(a.href);
if (clean !== a.href) a.href = clean;
});
}
});
});
});
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:Remove Tracking Parameters from Links]', __e); }
})();
(function(){
try {
var __m = "youtube.com";
var __re = new RegExp('^' + "youtube\\.com" + '
GitHub - RyanL1997/sql: Query your data using familiar SQL or intuitive Piped Processing Language (PPL) · GitHub
Skip to content
BranchesTags
Latest commit
History
2,373 Commits
Folders and files
NameName
Last commit message
Last commit date
.claude
.claude
.github
.github
api
api
async-query-core
async-query-core
async-query
async-query
benchmarks
benchmarks
build-tools
build-tools
buildSrc
buildSrc
common
common
core
core
datasources
datasources
direct-query-core
direct-query-core
direct-query
direct-query
docs
docs
doctest
doctest
gradle/wrapper
gradle/wrapper
integ-test
integ-test
language-grammar
language-grammar
legacy
legacy
opensearch
opensearch
plugin
plugin
ppl-rest-spi
ppl-rest-spi
ppl
ppl
prometheus
prometheus
protocol
protocol
release-notes
release-notes
scripts
scripts
spark
spark
sql
sql
.codecov.yml
.codecov.yml
.gitignore
.gitignore
.lycheeignore
.lycheeignore
.pre-commit-config.yaml
.pre-commit-config.yaml
.whitesource
.whitesource
ADMINS.md
ADMINS.md
CLAUDE.md
CLAUDE.md
CLAUDE_GUIDE.md
CLAUDE_GUIDE.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
CONTRIBUTORS.md
CONTRIBUTORS.md
DEVELOPER_GUIDE.rst
DEVELOPER_GUIDE.rst
LICENSE.txt
LICENSE.txt
MAINTAINERS.md
MAINTAINERS.md
NOTICE
NOTICE
README.md
README.md
RELEASING.md
RELEASING.md
SECURITY.md
SECURITY.md
THIRD-PARTY
THIRD-PARTY
build.gradle
build.gradle
gradle.properties
gradle.properties
gradlew
gradlew
gradlew.bat
gradlew.bat
lombok.config
lombok.config
settings.gradle
settings.gradle
Repository files navigation
OpenSearch SQL
OpenSearch enables you to extract insights out of OpenSearch using the familiar SQL or Piped Processing Language (PPL) query syntax. Use aggregations, group by, and where clauses to investigate your data. Read your data as JSON documents or CSV tables so you have the flexibility to use the format that works best for you.
The following projects are related to the SQL plugin, but stored in the different repos. Please refer to links below for details. This document will focus on the SQL plugin for OpenSearch.
Code Summary
SQL Engine
Test and build[![SQL CI][sql-ci-badge]][sql-ci-link]
Code coveragecodecov
Distribution build testsOpenSearch IT testsOpenSearch IT code
Backward compatibility testsBWC tests
Repository Checks
DCO Checker[![Developer certificate of origin][dco-badge]][dco-badge-link]
Link CheckerLink Checker
Issues
good first issues open
features open
enhancements open
bugs open
untriaged open
nolabel open
Highlights
Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualization. Please check our documentation for more details.
Recently we have been actively improving our query engine primarily for better correctness and extensibility. Behind the scene, the new enhanced engine has already supported both SQL and Piped Processing Language. Please find more details in SQL Engine V2 - Release Notes.
Documentation
Please refer to the SQL Language Reference Manual, Piped Processing Language (PPL) Reference Manual, OpenSearch SQL/PPL Engine Development Manual and Technical Documentation for detailed information on installing and configuring plugin.
Forum
For additional help with the plugin, including questions about opening an issue, visit the OpenSearch Forum.
Contributing
See developer guide and how to contribute to this project.
Attribution
This project is based on the Apache 2.0-licensed elasticsearch-sql project. Thank you eliranmoyal, shi-yuan, ansjsun and everyone else who contributed great code to that project. Read this for more details Attributions.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security
If you discover a potential security issue in this project we ask that you notify OpenSearch Security directly via email to security@opensearch.org. Please do not create a public GitHub issue.
License
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright OpenSearch Contributors. See NOTICE for details.
About
Query your data using familiar SQL or intuitive Piped Processing Language (PPL)
opensearch.org/docs/latest/search-plugins/sql/index/
Resources
Readme
License
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Stars
0 stars
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Auto-enable theater mode on YouTube
(function() {
function tryTheater() {
var btn = document.querySelector('button[aria-label="Theater mode"], ytd-player #player button[title="Theater mode"]');
if (btn && !btn.classList.contains('activated')) {
btn.click();
}
}
// Try immediately
tryTheater();
// Try after navigation (SPA)
var lastUrl = location.href;
setInterval(function() {
if (location.href !== lastUrl) {
lastUrl = location.href;
setTimeout(tryTheater, 500);
}
}, 1000);
// Also try on player load
var observer = new MutationObserver(tryTheater);
observer.observe(document.body, { childList: true, subtree: true });
})();
}
} catch(__e) { console.warn('[Userscript:YouTube Theater Mode Default]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '
GitHub - RyanL1997/sql: Query your data using familiar SQL or intuitive Piped Processing Language (PPL) · GitHub
Skip to content
BranchesTags
Latest commit
History
2,373 Commits
Folders and files
NameName
Last commit message
Last commit date
.claude
.claude
.github
.github
api
api
async-query-core
async-query-core
async-query
async-query
benchmarks
benchmarks
build-tools
build-tools
buildSrc
buildSrc
common
common
core
core
datasources
datasources
direct-query-core
direct-query-core
direct-query
direct-query
docs
docs
doctest
doctest
gradle/wrapper
gradle/wrapper
integ-test
integ-test
language-grammar
language-grammar
legacy
legacy
opensearch
opensearch
plugin
plugin
ppl-rest-spi
ppl-rest-spi
ppl
ppl
prometheus
prometheus
protocol
protocol
release-notes
release-notes
scripts
scripts
spark
spark
sql
sql
.codecov.yml
.codecov.yml
.gitignore
.gitignore
.lycheeignore
.lycheeignore
.pre-commit-config.yaml
.pre-commit-config.yaml
.whitesource
.whitesource
ADMINS.md
ADMINS.md
CLAUDE.md
CLAUDE.md
CLAUDE_GUIDE.md
CLAUDE_GUIDE.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
CONTRIBUTORS.md
CONTRIBUTORS.md
DEVELOPER_GUIDE.rst
DEVELOPER_GUIDE.rst
LICENSE.txt
LICENSE.txt
MAINTAINERS.md
MAINTAINERS.md
NOTICE
NOTICE
README.md
README.md
RELEASING.md
RELEASING.md
SECURITY.md
SECURITY.md
THIRD-PARTY
THIRD-PARTY
build.gradle
build.gradle
gradle.properties
gradle.properties
gradlew
gradlew
gradlew.bat
gradlew.bat
lombok.config
lombok.config
settings.gradle
settings.gradle
Repository files navigation
OpenSearch SQL
OpenSearch enables you to extract insights out of OpenSearch using the familiar SQL or Piped Processing Language (PPL) query syntax. Use aggregations, group by, and where clauses to investigate your data. Read your data as JSON documents or CSV tables so you have the flexibility to use the format that works best for you.
The following projects are related to the SQL plugin, but stored in the different repos. Please refer to links below for details. This document will focus on the SQL plugin for OpenSearch.
Code Summary
SQL Engine
Test and build[![SQL CI][sql-ci-badge]][sql-ci-link]
Code coveragecodecov
Distribution build testsOpenSearch IT testsOpenSearch IT code
Backward compatibility testsBWC tests
Repository Checks
DCO Checker[![Developer certificate of origin][dco-badge]][dco-badge-link]
Link CheckerLink Checker
Issues
good first issues open
features open
enhancements open
bugs open
untriaged open
nolabel open
Highlights
Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualization. Please check our documentation for more details.
Recently we have been actively improving our query engine primarily for better correctness and extensibility. Behind the scene, the new enhanced engine has already supported both SQL and Piped Processing Language. Please find more details in SQL Engine V2 - Release Notes.
Documentation
Please refer to the SQL Language Reference Manual, Piped Processing Language (PPL) Reference Manual, OpenSearch SQL/PPL Engine Development Manual and Technical Documentation for detailed information on installing and configuring plugin.
Forum
For additional help with the plugin, including questions about opening an issue, visit the OpenSearch Forum.
Contributing
See developer guide and how to contribute to this project.
Attribution
This project is based on the Apache 2.0-licensed elasticsearch-sql project. Thank you eliranmoyal, shi-yuan, ansjsun and everyone else who contributed great code to that project. Read this for more details Attributions.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security
If you discover a potential security issue in this project we ask that you notify OpenSearch Security directly via email to security@opensearch.org. Please do not create a public GitHub issue.
License
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright OpenSearch Contributors. See NOTICE for details.
About
Query your data using familiar SQL or intuitive Piped Processing Language (PPL)
opensearch.org/docs/latest/search-plugins/sql/index/
Resources
Readme
License
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Stars
0 stars
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
// Remove or un-stick sticky/fixed headers that block content
(function() {
function unstick() {
document.querySelectorAll('header, nav, [role="banner"], .header, .navbar, .sticky, .fixed-top, [style*="position: fixed"], [style*="position:sticky"]').forEach(function(el) {
if (el.style.position === 'fixed' || el.style.position === 'sticky' || getComputedStyle(el).position === 'fixed' || getComputedStyle(el).position === 'sticky') {
el.style.position = 'static';
el.style.top = 'auto';
el.style.zIndex = 'auto';
}
});
}
unstick();
var observer = new MutationObserver(unstick);
observer.observe(document.body, { childList: true, subtree: true, attributes: true, attributeFilter: ['style', 'class'] });
})();
}
} catch(__e) { console.warn('[Userscript:Kill Sticky Headers]', __e); }
})();
})();
GitHub - RyanL1997/sql: Query your data using familiar SQL or intuitive Piped Processing Language (PPL) · GitHub
Skip to content
BranchesTags
Latest commit
History
2,373 Commits
Folders and files
NameName
Last commit message
Last commit date
.claude
.claude
.github
.github
api
api
async-query-core
async-query-core
async-query
async-query
benchmarks
benchmarks
build-tools
build-tools
buildSrc
buildSrc
common
common
core
core
datasources
datasources
direct-query-core
direct-query-core
direct-query
direct-query
docs
docs
doctest
doctest
gradle/wrapper
gradle/wrapper
integ-test
integ-test
language-grammar
language-grammar
legacy
legacy
opensearch
opensearch
plugin
plugin
ppl-rest-spi
ppl-rest-spi
ppl
ppl
prometheus
prometheus
protocol
protocol
release-notes
release-notes
scripts
scripts
spark
spark
sql
sql
.codecov.yml
.codecov.yml
.gitignore
.gitignore
.lycheeignore
.lycheeignore
.pre-commit-config.yaml
.pre-commit-config.yaml
.whitesource
.whitesource
ADMINS.md
ADMINS.md
CLAUDE.md
CLAUDE.md
CLAUDE_GUIDE.md
CLAUDE_GUIDE.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
CONTRIBUTORS.md
CONTRIBUTORS.md
DEVELOPER_GUIDE.rst
DEVELOPER_GUIDE.rst
LICENSE.txt
LICENSE.txt
MAINTAINERS.md
MAINTAINERS.md
NOTICE
NOTICE
README.md
README.md
RELEASING.md
RELEASING.md
SECURITY.md
SECURITY.md
THIRD-PARTY
THIRD-PARTY
build.gradle
build.gradle
gradle.properties
gradle.properties
gradlew
gradlew
gradlew.bat
gradlew.bat
lombok.config
lombok.config
settings.gradle
settings.gradle
Repository files navigation
OpenSearch SQL
OpenSearch enables you to extract insights out of OpenSearch using the familiar SQL or Piped Processing Language (PPL) query syntax. Use aggregations, group by, and where clauses to investigate your data. Read your data as JSON documents or CSV tables so you have the flexibility to use the format that works best for you.
The following projects are related to the SQL plugin, but stored in the different repos. Please refer to links below for details. This document will focus on the SQL plugin for OpenSearch.
Code Summary
SQL Engine
Test and build[![SQL CI][sql-ci-badge]][sql-ci-link]
Code coveragecodecov
Distribution build testsOpenSearch IT testsOpenSearch IT code
Backward compatibility testsBWC tests
Repository Checks
DCO Checker[![Developer certificate of origin][dco-badge]][dco-badge-link]
Link CheckerLink Checker
Issues
good first issues open
features open
enhancements open
bugs open
untriaged open
nolabel open
Highlights
Besides basic filtering and aggregation, OpenSearch SQL also supports complex queries, such as querying semi-structured data, JOINs, set operations, sub-queries etc. Beyond the standard functions, OpenSearch functions are provided for better analytics and visualization. Please check our documentation for more details.
Recently we have been actively improving our query engine primarily for better correctness and extensibility. Behind the scene, the new enhanced engine has already supported both SQL and Piped Processing Language. Please find more details in SQL Engine V2 - Release Notes.
Documentation
Please refer to the SQL Language Reference Manual, Piped Processing Language (PPL) Reference Manual, OpenSearch SQL/PPL Engine Development Manual and Technical Documentation for detailed information on installing and configuring plugin.
Forum
For additional help with the plugin, including questions about opening an issue, visit the OpenSearch Forum.
Contributing
See developer guide and how to contribute to this project.
Attribution
This project is based on the Apache 2.0-licensed elasticsearch-sql project. Thank you eliranmoyal, shi-yuan, ansjsun and everyone else who contributed great code to that project. Read this for more details Attributions.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security
If you discover a potential security issue in this project we ask that you notify OpenSearch Security directly via email to security@opensearch.org. Please do not create a public GitHub issue.
License
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright OpenSearch Contributors. See NOTICE for details.
About
Query your data using familiar SQL or intuitive Piped Processing Language (PPL)
opensearch.org/docs/latest/search-plugins/sql/index/
Resources
Readme
License
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Stars
0 stars
Watchers
0 watching
Forks
0 forks
Report repository
Releases
Packages
Contributors
Languages