https://www.elastic.co/what-is/elasticsearch-sql [elasticon-] [elasticon-] Attend ElasticON Comes to You in person or virtually to illuminate your search possibilities. Find an event near you elastic-logo.svg * Platform * Use cases * Pricing * Customers * Resources * Company logo-cloud-32-color.svg Elastic Cloud Maximize value and optimize your experience Deploy everything Elastic has to offer across any cloud, in minutes. Learn more Additional Resources * icon-price-16-blue.svgView pricing * icon-download-16-blue.svgFree trial and downloads * icon-integration-16-blue.svgView all integrations Use Elastic For * logo-enterprise-search-32-color.svg Enterprise Search Search and discovery experiences * logo-observability-32-color.svg Observability Unified logs, metrics, and traces * logo-security-32-color.svg Security SIEM, endpoint, cloud, and XDR * logo-cloud-32-color.svg Elastic Cloud Deploy and scale in any cloud * logo-stack-32-color.svg Elastic (ELK) Stack Elasticsearch, Kibana, and integrations View platform overview What's New * Elastic 8.4 released Streamlined data integrations * Upgrade the Elastic Stack Expert tips when upgrading * Documentation Read latest product guides * ElasticON Comes To You 2022 Join us in a city near you * We're hiring Join a global, distributed team * By Topic + Improving digital customer experiences Connecting people with content that matters + Evolving the DevOps lifecycle Building better applications efficiently and at scale + Security without limits Limitless visibility, analytics, and response capabilities View all topics * By Industry + Public Sector + Financial Services + Telecommunications + Healthcare + Technology + Retail and Ecommerce + Media and Entertainment + Manufacturing and Automotive View all industries * Featured [enterprise] Secret ingredient for better website experience Boost conversions, lower bounce rates, and conquer abandoned shopping carts Download ebook Stories By Use Case * Enterprise Search Search applications of all kinds * Observability Logs, metrics, APM, and more * Security SIEM, endpoint, cloud, and XDR Help Center * Getting started Guidance to get started * Support Get help and customer resources * Contact us Have questions? Get in touch Featured Customers * logo-nav-dropdown-48x48-jaguar.png Jaguar Land Rover Vehicle intelligence * logo-nav-dropdown-48x48-emirates-nbd.png Emirates NBD Secured billions in assets * logo-nav-dropdown-48x48-zurich.png Zurich Insurance Increased customer trust View all case studies Learn * Documentation Product guides * Blogs Tech topics, innovation, news * Training Skill building and certification Engage * Events ElasticON, meetups, virtual events * Community Groups, forums, code * Consulting Outcome-based services Featured * icon-blog-pencil-32-color.svg Driving quantified success with Elastic Enterprise Search * icon-training-on-demand-32-color.svg Get started with Elasticsearch * icon-certificate-award-32-color.svg Observability Engineer training View all resources * About Elastic + About Our story and leadership + Careers Peruse our opportunities + Press Elastic news + Partners Find or become a partner + Investor Relations Results, filings, resources + Elastic Excellence Awards See remarkable work * Featured [Critical_d] Why now is the time to move critical databases to the cloud Read more ContactLogin Try freeicon-magnifying-glass-24-blue.svg elastic-logo.svg icon-magnifying-glass-24-blue.svgicon-magnifying-glass-24-blue.svg * Platform * Use cases * Pricing * Customers * Resources * Company [icon-left-] Platform Featured * logo-cloud-32-color.svgElastic Cloud * icon-price-16-blue.svgView pricing * icon-download-16-blue.svgFree trial and downloads * icon-integration-16-blue.svgView all integrations Use Elastic For * logo-enterprise-search-32-color.svg Enterprise Search Search and discovery experiences * logo-observability-32-color.svg Observability Unified logs, metrics, and traces * logo-security-32-color.svg Security SIEM, endpoint, cloud, and XDR * logo-cloud-32-color.svg Elastic Cloud Deploy and scale in any cloud * logo-stack-32-color.svg Elastic (ELK) Stack Elasticsearch, Kibana, and integrations View platform overview What's New * Elastic 8.4 released Streamlined data integrations * Upgrade the Elastic Stack Expert tips when upgrading * Documentation Read latest product guides * ElasticON Comes To You 2022 Join us in a city near you * We're hiring Join a global, distributed team [icon-left-] Use cases By Topic Improving digital customer experiences Connecting people with content that matters Evolving the DevOps lifecycle Building better applications efficiently and at scale Security without limits Limitless visibility, analytics, and response capabilities View all topics By Industry Public Sector Financial Services Telecommunications Healthcare Technology Retail and Ecommerce Media and Entertainment Manufacturing and Automotive View all industries FeaturedSecret ingredient for better website experience [icon-left-] Customers Stories By Use Case * Enterprise Search Search applications of all kinds * Observability Logs, metrics, APM, and more * Security SIEM, endpoint, cloud, and XDR Help Center * Getting started Guidance to get started * Support Get help and customer resources * Contact us Have questions? Get in touch Featured Customers * logo-nav-dropdown-48x48-jaguar.png Jaguar Land Rover Vehicle intelligence * logo-nav-dropdown-48x48-emirates-nbd.png Emirates NBD Secured billions in assets * logo-nav-dropdown-48x48-zurich.png Zurich Insurance Increased customer trust View all case studies [icon-left-] Resources Learn * Documentation Product guides * Blogs Tech topics, innovation, news * Training Skill building and certification Engage * Events ElasticON, meetups, virtual events * Community Groups, forums, code * Consulting Outcome-based services Featured * icon-blog-pencil-32-color.svg Driving quantified success with Elastic Enterprise Search * icon-training-on-demand-32-color.svg Get started with Elasticsearch * icon-certificate-award-32-color.svg Observability Engineer training View all resources [icon-left-] Company About Elastic About Our story and leadership Careers Peruse our opportunities Press Elastic news Partners Find or become a partner Investor Relations Results, filings, resources Elastic Excellence Awards See remarkable work FeaturedWhy now is the time to move critical databases to the cloud Try free Have questions? Contact us Already have an account? Log in Elastic Stack Features Capabilities + Stack security + Machine learning + Geospatial Elasticsearch + Overview + Features + Elasticsearch Service + Elasticsearch searchable snapshots + Elasticsearch runtime fields Kibana + Overview + Features + Kibana Canvas + Kibana Lens + Kibana dashboard + Kibana alerting + Elastic Maps + Elastic Maps Service Integrations + Overview + Data integrations + Elastic Agent + Beats + Logstash + Web crawler + Content connectors Docs [icon-sql-3] Elasticsearch SQL Tap into Elasticsearch with a familiar syntax Elasticsearch has the speed, scale, and flexibility your data needs -- and it speaks SQL. Use traditional database syntax to unlock non-traditional performance, like full text search across petabytes of data with real-time results. Get started Elasticsearch SQL documentation Getting started with Elasticsearch: Store, search, and analyze with the free and open Elastic Stack. Watch video Intro to ELK: Get started with logs, metrics, data ingestion and custom vizualizations in Kibana. Watch video Getting started with Elastic Cloud: Launch your first deployment. Learn more Scalable search with scoring ... and SQL Elasticsearch is a full text search engine with all the goodies you'd expect, like relevance scoring, stemming, synonyms, and more. And since it's a distributed document store -- with horizontal scalability -- it can handle billions of rows of data without skipping a beat. With Elasticsearch SQL, you can access that full text search, blazing speed, and effortless scalability with a familiar query syntax. Screenshot Familiar requests with faster responses Use your SQL skills to query data within Elasticsearch, harnessing the power of Elastic with a familiar language. Send your SQL queries via a CLI, REST endpoint, ODBC, or JDBC to get your results with newfound speed. You'll even see your results in the same tabular views you've been getting since your first SELECT statement. It's Canvas-ready Use Elasticsearch SQL query syntax to build live, infographic-style presentations in Canvas. Query, aggregate, and shape your Elasticsearch data with SQL syntax -- painting your data points into a story that goes beyond the grid. Canvas animation Stick to SQL or dive into Query DSL Learning a new language requires either a good teacher or a good dictionary. With our Elasticsearch SQL translate functionality, you get both. Every time you run a SQL command, you can see the exact Query DSL statement being run against your data in Elasticsearch. Once you're comfortable, take your queries a step further by trying out our expansive Query DSL. SQL translate animation [pattern-fo] [pattern-fo] [pattern-fo] [pattern-fo] Try Elasticsearch SQL Find out for yourself how easy it is to query Elasticsearch data with SQL. Have questions? Visit the Elasticsearch SQL documentation or join us on the Elasticsearch SQL forum. Get started Subscribe to our newsletter Follow us * Follow us on Twitter * Follow us on Facebook * Follow us on Youtube * Follow us on LinkedIn Products & Solutions * Enterprise Search * Observability * Security * Elastic Stack * Elasticsearch * Kibana * Integrations * Subscriptions * Pricing Company * Careers We're hiring * Board of Directors * Contact Resources * Documentation * What is the ELK Stack? * What is Elasticsearch? * Migrating from Splunk * OpenSearch vs. Elasticsearch * Public Sector Follow us * [footer-ico] * [footer-ico] * [footer-ico] * [footer-ico] Language [Deutsch ] Elastic * Trademarks * Terms of Use * Privacy * Sitemap (c) 2022. Elasticsearch B.V. All Rights Reserved Elasticsearch is a trademark of Elasticsearch B.V., registered in the U.S. and in other countries. Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries. (c) 2022. Elasticsearch B.V. All Rights Reserved Elastic