Category Archives: Unique

The unique features about esProc.

Structured Data Computing: the Focus of Routine Data Analysis

Essentially, the main content of various data analyses in our routine business is the structured data computing. For example: Compute the link relative ratio and year-on-year comparison of each business branch’s monthly sales during a specified period of time. Implementation … Continue reading

Posted in Unique | Tagged , , , | Leave a comment

Constants in esProc

In esProc computing, we may frequently use constants or store the data in the cell directly. In this article, let’s learn the usage of constants in the esProc. 1.Directly using constant in the expression Constants can be directly used in … Continue reading

Posted in Data Analytics, Unique | Tagged , | Leave a comment

Alignment Grouping and Enumeration Grouping in esProc

Grouping records is often required during presenting and analyzing data in databases. Though records can group the designated fields by using Group By statement in SQL statements, this type of grouping serving the purpose of summary is too simple to … Continue reading

Posted in Unique | Tagged , , , | Leave a comment

esProc’s Option Syntax

1. esProc’s function options Many functions in esProc can use function options with which the same function can have different work patterns. The basic format of function options is f@o(…) in which o is f function’s option. For example: We … Continue reading

Posted in Unique | Tagged , | Leave a comment

Binary File in esProc

In esProc, we often use two kinds of data file: The normal txt file and the binary file, of which the binary file adopts compressed encoding of low CUP consumption, meaning that a compressed binary file will take less space … Continue reading

Posted in Program Language, Unique | Tagged , | Leave a comment

Process Text Files with esProc

It is quite convenient to process data from text files with esProc, which provides many functions for processing text files: import various text files; process big text files; visit text files of hdfs; as well as general operations, such as, … Continue reading

Posted in Program Language, Unique | Tagged , | Leave a comment

Principle and Use of External Memory Sorting in esProc

It is often required to sort records of tables during data analysis and computing. In esProc, sort function is used to sort data of sequences or table sequences. External memory sorting is required when data being sorted are massive and … Continue reading

Posted in Data Analytics, Program Language, Unique | Tagged , , , | Leave a comment