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

Multi-grammar processing method and device for computing platform and readable storage medium

A grammar processing and computing platform technology, applied in computing, digital data processing, special data processing applications, etc., can solve problems such as high labor costs, reduce labor costs, speed up the deployment process, and enhance the effect of privatization experience

Active Publication Date: 2022-03-01
深圳市明源云科技有限公司
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a multi-syntax processing method for a computing platform, aiming to solve the technical problem of manually modifying the statement SQL statement to be compatible with the Presto platform and having relatively high labor costs

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
  • Multi-grammar processing method and device for computing platform and readable storage medium
  • Multi-grammar processing method and device for computing platform and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0071] refer to figure 2 , the first embodiment of the multi-syntax processing method of the computing platform of the present invention, the multi-syntax processing method of the computing platform includes:

[0072] Step S10, when the Presto platform receives an SQL statement not based on the Presto platform, perform semantic analysis on the SQL statement to generate a set of table fields contained in the SQL statement;

[0073] In this embodiment, the above-mentioned Presto platform belongs to an MMP (Massively Parallel Processor) real-time computing engine in the Apache open source community. The above-mentioned non-mentioned Presto platform is the subsequent offline data warehouse analysis platform such as the MaxCompute platform and the Hive platform, and the MaxCompute platform is Alibaba Cloud's commercial offline data warehouse storage and analysis platform, and the Hive platform are offline data warehouse analysis platforms that support privatized deployments in the...

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 multi-grammar processing method and device for a computing platform and a readable storage medium, and the multi-grammar processing method for the computing platform comprises the steps: when a Presto platform receives an SQL statement written based on a non-Presto platform, carrying out semantic analysis on the SQL statement, and generating a table field set contained in the SQL statement; extracting analysis table fields participating in the association analysis process of the SQL statement in the table field set, and performing data type unified conversion on numerical data of the analysis table fields in the Presto platform to obtain a compatible operation environment of the SQL statement; and based on the Presto platform, in the compatible operation environment, executing the SQL statement to generate a data report. The Presto platform can correctly execute SQL statements based on other platforms, a developer does not need to modify the SQL statements, and the private deployment process of a client big data cluster platform is accelerated.

Description

technical field [0001] The invention relates to the field of data migration of an offline data warehouse storage and analysis platform, in particular to a multi-syntax processing method, device and readable storage medium of a computing platform. Background technique [0002] Based on Presto's self-developed data platform, when migrating historical reports from other offline data warehouse storage and analysis platforms to its own platform, there is a problem of SQL (Structured Query Language, Structured Query Language) syntax incompatibility, which leads to errors in the generation of historical reports on its own Presto platform . For example, migrating reports developed on the MaxCompute platform or the Hive platform to the Presto platform presents huge human efficiency and technical challenges. At present, the common practice in the industry is to manually modify the SQL statements of the reports developed on the MaxCompute platform or the Hive platform to be compatible...

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): G06F16/21G06F16/242G06F16/28
CPCG06F16/283G06F16/214G06F16/2435
Inventor 万义
Owner 深圳市明源云科技有限公司