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

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

A syntax processing and computing platform technology, applied in computing, digital data processing, special data processing applications, etc., can solve problems such as high labor costs, achieve the effects of reducing labor costs, accelerating the deployment process, and improving the sense of privatization experience

Active Publication Date: 2022-05-27
深圳市明源云科技有限公司
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-syntax processing method, device and readable storage medium for computing platform
  • Multi-syntax processing method, device and readable storage medium for computing platform

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

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

[0072] Step S10, when the Presto platform receives the SQL statement that is not written based on the Presto platform, semantically parses the SQL statement, and generates a table field collection included 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 Hive platform are mainstream offline data warehouse analysis platforms that support privatiz...

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-syntax processing method, device and readable storage medium of a computing platform. The multi-syntax processing method of the computing platform includes: when the Presto platform receives an SQL statement not written on the basis of the Presto platform, the The SQL statement is semantically analyzed to generate a set of table fields contained in the SQL statement; the analysis table fields participating in the associated analysis process of the SQL statement in the set of table fields are extracted, and the analysis table fields are included in the The numerical data in the Presto platform is uniformly converted into data types to obtain a compatible operating environment of the SQL statement; based on the Presto platform in the compatible operating environment, the SQL statement is executed to generate a data report. This enables the Presto platform to correctly execute SQL statements based on other platforms without modification by developers, and accelerates the privatization deployment process of the customer's big data cluster platform.

Description

technical field [0001] The invention relates to the field of data migration of offline data warehouse storage and analysis platforms, in particular to a multi-grammar processing method, device and readable storage medium of a computing platform. Background technique [0002] Based on the Presto 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 incompatibility of SQL (Structured Query Language, Structured Query Language) syntax, resulting in 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 poses huge human and technical challenges. However, the current industry practice is to manually modify the SQL statements of the reports developed on the MaxCompute platform or Hive platform to be compatible with the Presto platform...

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