SQL use method based on Elasticsearch

Abstract

The invention discloses an SQL use method based on Elasticsearch. The method is used for solving the problems that an existing Elasticsearch query is complex in grammar, not easy to understand semantically, redundant in structure and inconvenient to query, and comprises the following steps: deploying an SQL engine, and enabling a client to receive and transmit queried SQL statements through a Restservice; obtaining a query result from the cache; analyzing the SQL statement through a syntax tree, and constructing a native query syntax of Elasticsearch after the syntax is enhanced. The invention uses a general SQL standard, so that the query availability of Elasticsearch is improved, the use is convenient, the learning cost is low, and the error rate is reduced; grammar enhancement: a rangecan be extracted in a search condition, so that a search result is accurate, synonym conversion is increased, and a search data result can be more comprehensive.

Description

technical field [0001] The invention relates to the technical field of SQL query, in particular to an Elasticsearch-based SQL usage method. Background technique [0002] Elasticsearch is a full-text search engine built on Apache Lucene TM The base search engine is a real-time distributed search and analysis engine. [0003] Elasticsearch is also written in Java. It uses Lucene for indexing and searching internally, but its purpose is to make full-text search easy by hiding the complexity of Lucene. [0004] There are many communication methods for Elasticsearch, one is to communicate through the RESTful web interface, and the other is to communicate through the Java API to query related data. [0005] Operating Elasticsearch through the java API has high requirements for the technology stack and increases the cost of learning. To realize the query function, a large amount of code needs to be written to complete. When the version changes, the code needs to be refactored, ...

AI Technical Summary

Problems solved by technology

[0008] The purpose of the present invention is to propose a SQL usage method based on Elasticsearch in order to solve the problems that the existing Elasticsearch query syntax is complex, semantically difficult to understand, redundant in structure, and inconvenient for query operations; the syntax tree is the abstract syntax of SQL The tree-like representation of the structure, each node on the tree represents a structure in SQL, adopts the general SQL standard, improves the query availability of Elasticsearch, is easy to use, has low learning costs, and reduces the error rate; syntax enhancement: in the search condition The scope can be extracted to make the search results accurate and increase the conversion of synonyms, which can make the search data results more comprehensive;

Images