DEV Community

# esproc

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Uncertain number but regular column to row conversion:From SQL to SPL#5

Uncertain number but regular column to row conversion:From SQL to SPL#5

5
Comments
2 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
Something Could Double the Development Efficiency of Java Programmers

Something Could Double the Development Efficiency of Java Programmers

9
Comments
6 min read
Add records that meet the criteria before each group after grouping :From SQL to SPL

Add records that meet the criteria before each group after grouping :From SQL to SPL

5
Comments
2 min read
Multi combination condition grouping and aggregation #eg93

Multi combination condition grouping and aggregation #eg93

7
Comments
1 min read
Split a Huge CSV File into Multiple Smaller CSV Files #eg69

Split a Huge CSV File into Multiple Smaller CSV Files #eg69

6
Comments 1
1 min read
Group & Summarize a CSV File #eg68

Group & Summarize a CSV File #eg68

6
Comments 1
1 min read
Getting positions of members according to primary key values #eg58

Getting positions of members according to primary key values #eg58

6
Comments
1 min read
Getting members according to primary key values #eg63

Getting members according to primary key values #eg63

7
Comments
1 min read
How to Access Databases using One SQL Statement #eg71

How to Access Databases using One SQL Statement #eg71

6
Comments
1 min read
Filter a CSV file and re-arrange it by category #eg60

Filter a CSV file and re-arrange it by category #eg60

6
Comments 1
1 min read
Getting positions of members based on a specified condition #eg46

Getting positions of members based on a specified condition #eg46

11
Comments
1 min read
Convert Each Whites-space-separated Text Block into a Row #eg62

Convert Each Whites-space-separated Text Block into a Row #eg62

6
Comments
1 min read
Perform Distinct on Ordered Numbers in a Text File #eg61

Perform Distinct on Ordered Numbers in a Text File #eg61

6
Comments
1 min read
Parse a csv file having a primary-sub tables structure #eg41

Parse a csv file having a primary-sub tables structure #eg41

6
Comments
2 min read
Convert CSV Data into Multilevel JSON #eg56

Convert CSV Data into Multilevel JSON #eg56

6
Comments
1 min read
Add a compute column to a csv file #eg40

Add a compute column to a csv file #eg40

6
Comments
1 min read
SQL, in each group modify the null value of a specified column as its neighboring value #eg43

SQL, in each group modify the null value of a specified column as its neighboring value #eg43

7
Comments
1 min read
Get the whole group where at least one member meets the specified condition #eg36

Get the whole group where at least one member meets the specified condition #eg36

6
Comments
2 min read
Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35

Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35

6
Comments
1 min read
Replace Duplicate Digits in Every 9-digit Number in a Text File with Non-duplicate Ones #eg52

Replace Duplicate Digits in Every 9-digit Number in a Text File with Non-duplicate Ones #eg52

7
Comments
1 min read
Reverse Rows in a Text File #eg51

Reverse Rows in a Text File #eg51

8
Comments 3
1 min read
The Difference between Each Value in a Certain Column and Its Previous One and Display Result

The Difference between Each Value in a Certain Column and Its Previous One and Display Result

6
Comments
2 min read
Java, perform COUNT on each group of a large csv file #eg33

Java, perform COUNT on each group of a large csv file #eg33

6
Comments
2 min read
SQL, extract unique values of JSON format field from each group #eg42

SQL, extract unique values of JSON format field from each group #eg42

6
Comments
2 min read
loading...