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

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

Active Publication Date: 2017-09-05
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF6 Cites 29 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 and device for inquiring elasticsearch cluster, electronic device and readable storage medium
  • Method and device for inquiring elasticsearch cluster, electronic device and readable storage medium
  • Method and device for inquiring elasticsearch cluster, electronic device and readable storage medium

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

The embodiment of the invention provides a method and device for inquiring an elasticsearch cluster, an electronic device and a readable storage medium. A front end user can conveniently inquire and use an ES cluster by compiling SQL statements under the situation that the ES cluster is unknown and JDBC connection does not need to be established. The method comprises the steps that an SQL inquiring statement input externally is obtained and analyzed to generate an index, and then connection with the ES cluster is established according to the index; the SQL inquiring statement is transformed into an ES inquiring request, and then the ES inquiring request is sent to the ES cluster through the connection; return results of the ES cluster are received and analyzed 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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/21G06F16/284
Inventor 刘凤云
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap