#esproc Development Tutorials & Tips | Roast Dev

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 divided into multiple time slices with fixed time length (like 15 minutes). If object a and object b ...

12.03.2025 0 Read More

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, it masters SQL with ease, effortlessly handling CTE recursive queries, multi-layered window functi...

19.03.2025 0 Read More

SPL: The Professional Choice for Processing Multi-Layered JSON Data

Business data often exhibits hierarchical relationships. For example, an order contains date, customer, and order details, with order details further containing price, quantity and product, and produc...

28.03.2025 0 Read More

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 duplicated. Now we need to merge multiple fields into one, remove null and duplicate values, and merge...

07.04.2025 0 Read More

How to Speed Up COUNT DISTINCT with esProc

The COUNT DISTINCT in SQL has always been relatively slow.De-duplication is essentially a grouping operation that requires retaining all the traversed grouping field values for subsequent comparisons....

09.04.2025 0 Read More

Statistics by time window: SPL VS SQL #16

The Time field of a certain database table is time, and the time interval is sometimes greater than 1 minute. Now we need to divide the data into windows every minute, fill in the missing windows, and...

22.04.2025 0 Read More

How to set duplicate content in a dataset to null with esProc

The first two fields of a certain database table may have duplicate values, such as the first three records below. Now we need to change all duplicate values to null. In other words, after grouping by...

24.04.2025 0 Read More

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 indirectly implement similar functions. In some cases, stored procedures are even used to drive ar...

24.04.2025 0 Read More

Local Data Analysis: DuckDB or esProc SPL?

DuckDB can directly read common files such as CSV, Parquet, and JSON. With just a single SQL statement, it can load the file and perform a query, such as SELECT * FROM ‘data.csv’ WHERE price>10...

27.04.2025 0 Read More

SPL Operates Multi-layer JSON Data Much More Conveniently than DuckDB

esProc SPL is much more convenient than DuckDB in operating multi-layer JSON data, particularly when preserving JSON hierarchy and performing complex calculations are required.DuckDB’s ability to op...

29.04.2025 0 Read More