Forem

# esproc

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Local Data Analysis: DuckDB or esProc SPL?

Local Data Analysis: DuckDB or esProc SPL?

6
Comments
2 min read
How to Speed Up Associations between Large Primary and Sub Tables with esProc

How to Speed Up Associations between Large Primary and Sub Tables with esProc

7
Comments 1
4 min read
Is This a Refreshing Way to Understand Association?

Is This a Refreshing Way to Understand Association?

6
Comments 1
7 min read
Using SQL for data analysis seems to be a false proposition

Using SQL for data analysis seems to be a false proposition

9
Comments 7
6 min read
How to Implement JOIN Operations Between Tables from Different Databases with esProc?

How to Implement JOIN Operations Between Tables from Different Databases with esProc?

6
Comments 1
8 min read
How to merge overlapping time intervals with esProc

How to merge overlapping time intervals with esProc

6
Comments 1
3 min read
Analyzing DuckDB’s Performance Optimization through TOPN and COUNT DISTINCT Operations

Analyzing DuckDB’s Performance Optimization through TOPN and COUNT DISTINCT Operations

6
Comments
5 min read
How to Implement Mixed Computations Between Oracle and MySQL with esProc

How to Implement Mixed Computations Between Oracle and MySQL with esProc

6
Comments 2
4 min read
esProc SPL: Equivalent to the Python-enhanced DuckDB

esProc SPL: Equivalent to the Python-enhanced DuckDB

5
Comments 2
2 min read
How to check the same status of data in each row within a group with esProc

How to check the same status of data in each row within a group with esProc

6
Comments
2 min read
How to Operate nested JSON from RESTful with esProc

How to Operate nested JSON from RESTful with esProc

6
Comments
4 min read
How to operate large CSV files with esProc SPL

How to operate large CSV files with esProc SPL

6
Comments 6
3 min read
How to quickly transform multi-layer sets in JSON strings

How to quickly transform multi-layer sets in JSON strings

7
Comments
2 min read
How to simplify the Merge Operations Across Tables from Multiple Databases

How to simplify the Merge Operations Across Tables from Multiple Databases

6
Comments
6 min read
How to supplement the missing capabilities of database SQL with esProc

How to supplement the missing capabilities of database SQL with esProc

6
Comments
6 min read
How to set duplicate content in a dataset to null with esProc

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

5
Comments
2 min read
Statistics by time window: SPL VS SQL #16

Statistics by time window: SPL VS SQL #16

6
Comments
3 min read
How to Speed Up COUNT DISTINCT with esProc

How to Speed Up COUNT DISTINCT with esProc

7
Comments
4 min read
Deduplicate between an uncertain number of columns:SQL VS SPL #15

Deduplicate between an uncertain number of columns:SQL VS SPL #15

7
Comments
2 min read
SPL: The Professional Choice for Processing Multi-Layered JSON Data

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

6
Comments
5 min read
esProc SPL: Combining the Strengths of DuckDB and Python

esProc SPL: Combining the Strengths of DuckDB and Python

5
Comments
4 min read
Space-time collision problem that renders MPP powerless to solve: SPL practice

Space-time collision problem that renders MPP powerless to solve: SPL practice

6
Comments
11 min read
Data Analysis Showdown: Comparing SQL, Python, and esProc SPL

Data Analysis Showdown: Comparing SQL, Python, and esProc SPL

7
Comments
5 min read
Running SQL on files with the esProc is very convenient, on par with duckDB

Running SQL on files with the esProc is very convenient, on par with duckDB

20
Comments
3 min read
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster ThanORACLE”anExaggeration?

Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster ThanORACLE”anExaggeration?

6
Comments
5 min read
loading...