Articles by Tag #esproc
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Running SQL on files with the esProc is very convenient, on par with duckDB
esProc SPL, to query CSV, JSON, Excel and other files, you can use it directly after installation,...
Querying CSV/XLS and other files：SPL Lightweight Multisource Mixed Computation Practices #2
It is convenient to access files with SPL. The language can also deal with various file formats. ...
Multi combination condition grouping and aggregation #eg93
The table in the MS SQL database is as follows, where id is the keyword: Now we need to first...
Something Could Double the Development Efficiency of Java Programmers
Computing dilemma in the application Development and Framework, which should be given the...
How to Speed Up Associations between Large Primary and Sub Tables with esProc
Associations between primary and sub tables, like orders and order details tables, are quite common....
Structured Text computing: SPL Practice
Structured Text Computing Requirements Structured text files are a common data storage...
How to quickly transform multi-layer sets in JSON strings
There is a 2-layer JSON string with multiple dynamic key values in the lower layer, excluding...
Data Analysis Showdown: Comparing SQL, Python, and esProc SPL
Talk is cheap; let’s show the codes. User Session Count User behavior data table A session is...
SPL: The Professional Choice for Processing Multi-Layered JSON Data
Business data often exhibits hierarchical relationships. For example, an order contains date,...
How to Speed Up Conditional Filtering on Enumerated Fields with esProc
Enumerated fields in data tables have a limited number of predefined values. Filtering conditions on...
Mixed-Source Computing：SPL Practices
Background The sources and storage forms and types of data in an application are diverse,...
A Lightweight Solution to Speed up Queries by Dumping Data to Files
Traditional transactional databases (TP) do not good at handling analytical computations....
Using SQL for data analysis seems to be a false proposition
Using SQL for data anlysis is actually quite basic SQL is widely used for data analysis and often...
SPL Lightweight Multisource Mixed Computation Practices
0 Preparation Background Multiple or diverse-source mixed computations are common needs....
How to supplement the missing capabilities of database SQL with esProc
Some database SQL lacks necessary capabilities and usually requires writing large sections of code to...
How to Operate nested JSON from RESTful with esProc
After receiving JSON from RESTful services, further calculations are often required. Processing such...
Cross-datasource JOIN：SPL Lightweight Multisource Mixed Computation Practice #6
Mixed computations between different structure data coming from multiple sources are more commonly...
How to Speed Up COUNT DISTINCT with esProc
The COUNT DISTINCT in SQL has always been relatively slow. De-duplication is essentially a grouping...
Deduplicate between an uncertain number of columns：SQL VS SPL #15
A certain database table has multiple fields, each storing an email address, which may be null or...
SQL migration : SPL Lightweight Multisource Mixed Computation Practice #7
The application may work based on different databases. Databases use similar SQL syntax, but they...
Space-time collision problem that renders MPP powerless to solve: SPL practice
Problem description Definition of space-time collision A certain time interval (such as 7 days) is...
Simulating Multiple-Layer Loop to Solve Logical Problems
Please write a program to solve the following 10 questions: Which question is the first question...
How to simplify the Merge Operations Across Tables from Multiple Databases
Due to business requirements, data is stored by year in two structurally identical databases. To...
esProc SPL: Combining the Strengths of DuckDB and Python
That DuckDB is gaining more and more attention is no accident. As a rising star in desktop analytics,...
How to Speed Up EXISTS in Primary-Subtable Joins with esProc
In databases, EXISTS operations between large primary and sub tables often result in poor...
How to Implement Mixed Computations Between Oracle and MySQL with esProc
Logical data warehouses can implement multi-source mixed computations, but require configuring views...
How to check the same status of data in each row within a group with esProc
The ID field of a certain database table is the grouping field of cars, and each group of cars is...
How to merge overlapping time intervals with esProc
A certain database table has multiple accounts, each with multiple time intervals that overlap. Now...
Is This a Refreshing Way to Understand Association?
The definition of association in SQL is overly simplistic: association is essentially performing a...
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster ThanORACLE”anExaggeration?
We often hear about the advertisements for the performance of a big data product, saying that it is...