Posted On: May 29, 2019
New SQL support enables you to query your domain using the familiar SQL syntax without compromising on Elasticsearch’s full-text search and scoring capabilities. With SQL support, you can query your data using aggregations, group by, and where clauses to investigate your data.
Amazon Elasticsearch Service supports more than 40 SQL functions, data types, and commands, including direct export to CSV and query translation from SQL to the Elasticsearch DSL. You can run SQL queries against your domains with the built-in REST API and the Kibana Dev Console. SQL also supports a JDBC driver to connect to your favorite SQL tools.
SQL support is available on domains running Elasticsearch 6.3 and higher. You can upgrade existing 5.x and 6.x domains with no downtime using in-place version upgrades. To learn more about SQL support on Amazon Elasticsearch Service, see the documentation.
SQL support on Amazon Elasticsearch Service is available across 21 regions globally: US East (N. Virginia, Ohio), US West (Oregon, N. California), Amazon Web Services GovCloud (US-Gov-East, US-Gov-West), Canada (Central), South America (Sao Paulo), EU (Ireland, London, Frankfurt, Paris, Stockholm), Asia Pacific (Singapore, Sydney, Tokyo, Seoul, Mumbai, Hong Kong), Amazon Web Services China (Beijing) region, operated by Sinnet, and Amazon Web Services China (Ningxia) region, operated by NWCD. Please refer to the Amazon Web Services Region Table for more information about Amazon Elasticsearch Service availability.