Supercharge Your Innovation With Domain-Expert AI Agents!

Big data SQL program design method based on configurable parameters

A technology for configuring parameters and big data, which is applied in the fields of electrical digital data processing, digital data information retrieval, special data processing applications, etc., can solve cumbersome problems and achieve the effect of simplifying development

Inactive Publication Date: 2022-01-21
北京科杰科技有限公司
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In addition, during the use of technical products, users need to fill in repetitive parameters and variables cumbersomely and repeatedly, which brings unnecessary workload and checks whether the values ​​are correct

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
  • Big data SQL program design method based on configurable parameters
  • Big data SQL program design method based on configurable parameters
  • Big data SQL program design method based on configurable parameters

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The present invention will be described below in conjunction with the drawings, and the present embodiment gives a detailed embodiment and the specific operation process, but the scope of the invention is not limited to this Embodiment.

[0019] This embodiment provides a large data SQL programming method based on configurable parameters, such as figure 1 As shown, the specific process is:

[0020] S1, create parameters in parameter management, and perform the parameter value corresponding to the configuration parameters according to the parameter type.

[0021] When S2, SQL development, the SQL statement is filled in the system development platform, supports the parameters created in step S1 in the step S1 in the system development platform.

[0022] S3, by getting the SQL statement, resolving, checking, and converting the SQL statement;

[0023] S4, the obtained SQL statement is converted according to step S3, and the HIVE or IMPALA is connected via the JDBC manner.

[00...

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 big data SQL program design method based on configurable parameters, which specifically comprises the following steps: S1, creating parameters in parameter management, and configuring parameter value contents corresponding to the parameters according to parameter types; s2, during SQL development, SQL statements are filled in a system development platform, HIVE, SPARKSQL and IMPALA are supported, and the parameters created in the step S1 can be quoted in SQL statement filling; s3, analyzing, verifying and converting the SQL statements by acquiring the SQL statements; and S4, according to the SQL statement obtained through conversion in the step S3, connecting HIVE or IMPALA in a JDBC mode for execution. According to the invention, various parameters are configured in advance, so that relevant parameters can be directly referenced when the SQL program is developed, a set of configured, standard and unified system is formed, and the development is simplified.

Description

Technical field [0001] The present invention relates to the field of SQL program development, and more particularly to a large data SQL programming method based on configurable parameters. Background technique [0002] At present, existing big data products are implemented and verify the SQL statements in the process of executing SQL, and finally send the SQL statement to the execution engine to calculate the results. In addition, during the use of technical products, users need to be cumbersome and repeatedly filled in, which will have unnecessary workloads and to check whether the value is correct. Inventive content [0003] For the shortcomings of the prior art, the present invention is intended to provide a large data SQL programming method based on configurable parameters. [0004] In order to achieve the above object, the present invention adopts the following technical solution: [0005] A large data SQL program design method based on configurable parameters, the specific...

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/242G06F16/2455
CPCG06F16/2433G06F16/2455
Inventor 于洋高经郡张洋洋
Owner 北京科杰科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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