Unlock instant, AI-driven research and patent intelligence for your innovation.

Method, device, electronic device and readable storage medium for querying elasticsearch cluster

A clustering and query statement technology, applied in the computer field, can solve the problems of complex structure, reduced access rate, and large memory usage of ES cluster, achieving the effect of low coupling and improving development progress.

Active Publication Date: 2021-01-26
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] 2. Using the elasticsearch-sql plug-in in the ES cluster will cause the ES cluster to occupy too much memory and reduce the access rate. great difficulty
[0008] 3. The result set returned by the elasticsearch-sql plug-in is a native ES JSON string with a complex structure. Although it can be converted into a user-readable format through the rendering of the front-end JS for users to view, it is not suitable for user customization. poor supportability

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method, device, electronic device and readable storage medium for querying elasticsearch cluster
  • Method, device, electronic device and readable storage medium for querying elasticsearch cluster
  • Method, device, electronic device and readable storage medium for querying elasticsearch cluster

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0041] In the embodiment of the present invention, a middleware package is developed to encapsulate the operation of each step of querying the ES cluster using SQL, and data transmission is performed by establishing a connection with the ES cluster. It can rely on HTTP, Web Service, JSF (JingdongService Framework, namely "Jeff", JSF service is a set of service framework de...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

Embodiments of the present invention provide a method, device, electronic device, and readable storage medium for querying an elasticsearch cluster, which can facilitate front-end users to query and use ES by writing SQL statements without knowing the ES cluster and without establishing a JDBC connection. cluster. The method includes: acquiring an externally input SQL query statement, parsing it to generate an index, and then establishing a connection with the ES cluster according to the index; converting the SQL query statement into an ES query request, and then using the connection to sending the ES query request to the ES cluster; and receiving the returned result of the ES cluster, and parsing the returned result into a result set.

Description

technical field [0001] The present invention relates to the field of computer technology, in particular to a method, device, electronic equipment and readable storage medium for querying an elasticsearch cluster. Background technique [0002] elasticsearch (hereinafter referred to as ES) is an open source distributed search engine based on Lucene. In terms of big data search and analysis, ES can provide reliable guarantee close to real-time. Currently, ES as a real-time data search engine has been widely used in various scenarios [0003] In the prior art, elasticsearch-sql is mostly used to query ES clusters. elasticsearch-sql is a plug-in that uses SQL-like statements to query ES clusters. The plug-in provides SQL-like query methods, converts SQL-like statements into query languages ​​that ES clusters can recognize, and displays the query results on the page. [0004] When using the elasticsearch-sql plug-in, you need to install the plug-in in the ES cluster in advance....

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21G06F16/28
CPCG06F16/21G06F16/284
Inventor 刘凤云
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD