Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Realization method and system for querying elasticsearch

An implementation method and system implementation technology, applied in the field of data processing, can solve problems such as not supporting aliases, not providing API interface program calls, not supporting version 5.x, etc.

Active Publication Date: 2017-07-07
GUANGDONG UNIV OF TECH
View PDF4 Cites 49 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Because it does not exist in the form of a framework, it does not provide an API interface for calling in the program
And the plug-in only supports elasticsearch 2.3.x and below versions, not the latest 5.x version
Secondly, SQL query statement support is not enough, for example, aliases are not supported

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
  • Realization method and system for querying elasticsearch
  • Realization method and system for querying elasticsearch
  • Realization method and system for querying elasticsearch

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] The core of the present invention is to provide a calcite-based SQL query elasticsearch implementation method and system, which parses SQL statements and completes the adaptation and optimization of SQL to elasticsearch java API.

[0043] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0044] Below is the explanation of the main nouns that occur in the present embodiment:

[0045] Elastic...

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 invention discloses a calcite-based realization method for querying elasticsearch by an sql. The method comprises the steps of obtaining an input SQL statement; performing metadata verification on the SQL statement according to provided metadata; after the verification is passed, analyzing the SQL statement to obtain an SQL syntax tree; and converting the SQL syntax tree into a matching condition and a query execution action executable for the elasticsearch by utilizing an additional rule, and returning a query result set. According to the realization method, the SQL statement is analyzed, and the adaptation and optimization of the SQL to an elasticsearch java API are finished. The invention discloses a calcite-based realization system for querying the elasticsearch by the sql. The system has the abovementioned beneficial effects.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a method and system for implementing Calcite-based SQL query elasticsearch. Background technique [0002] Elasticsearch is a real-time distributed search and analysis engine. Its logical organization of data is similar to that of relational databases. For example, elasticsearch will index data, each index has a type, and each type has There is a corresponding mapping. These concepts are of the type database, table, and schema of relational databases. [0003] Elasticsearch provides a specific data query API interface (RESTful API or Java clientAPI), these interfaces need to learn elasticsearch to use better. Data analysis engineers are more familiar with the SQL language. In fact, IT software developers are basically more familiar with the SQL language. For elasticsearch, an engine / server that focuses on the search field, I don't know the same thing, and I don'...

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
IPC IPC(8): G06F17/30
CPCG06F16/2445G06F16/24534G06F16/2471
Inventor 杨佳佳谢胜利
Owner GUANGDONG UNIV OF TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com