A method of searching elasticsearch based on sql

Abstract

The invention relates to a method for retrieving ElasticSearch based on SQL. The method comprises steps: creating a Database Connection Pool, parsing the input SQL language, establishing a correspondence with ElasticSearch and splicing the parsed query language into query statements for ElasticSearch, RestClient being used to establish database connection with database connection pool and sendingretrieval request to ElasticSearch to convert the returned result to standard output. The present invention does not have compatibility problems due to ElasticSearch version updates, RestClient uses application layer http to call transport layer tcp to complete operation, reduces system overhead and improves performance. Database connection pool can meet the needs of creating multiple RestClient connections, and execute different SQL at the same time to solve the high concurrency problem.

Description

technical field [0001] The invention relates to the technical field of confidential or secure communication devices, in particular to a method for retrieving ElasticSearch based on SQL. Background technique [0002] ElasticSearch is an open source, Lucene-based search server that provides a distributed multi-user capable full-text search engine. In the big data industry, the distributed retrieval function of ElasticSearch is convenient for multi-dimensional data presentation, analysis, and prediction, which is conducive to the value of data. In China, many large companies, such as Massive, Ctrip, Sina, Baidu, etc., use ElasticSearch for search and analysis. [0003] At present, the function of ElasticSearch is mostly used for retrieval. As a popular enterprise-level search engine, ElasticSearch can solve many people's requirements for search. It uses JSON for data indexing through HTTP and does not support SQL. Therefore, in terms of using ElasticSearch for query, most peo...

AI Technical Summary

Problems solved by technology

[0006] The technical problem solved by the present invention is that in the prior art, because TransportClient uses TransportProtocol to communicate with ElasticSearch, when the versions of TransportClient and ElasticSearch instances are inconsistent, it is very easy to have compatibility problems, which brings a burden to developers and application program upgrades, and because TransportClient adopts the long connection method, which will also increase the overhead of the system. The present invention provides an optimized method for retrieving ElasticSearch based on SQL