Skip to content

DEV Community

# esprocspl

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Judith-Data-Processing-Hacks

Apr 11

Number Non-Null Values in Order within the Group — From SQL to SPL #17

#programming #sql #esprocspl #dataengineering

2 min read

Judith-Data-Processing-Hacks

Apr 14

Get the Records after and before the Searched One — From SQL to SPL #18

#programming #sql #esprocspl #dataengineering

2 min read

Judith-Data-Processing-Hacks

Apr 9

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

#programming #dataengineering #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Apr 2

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

#programming #datascience #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 31

Calculate the Number of Intersections between Adjacent Subsets after Grouping — From SQL to SPL #14

#database #sql #esprocspl #programming

2 min read

Feb 24

esProc SPL & MongoDB: A Match Made in Data Heaven

#mongodb #database #opensource #esprocspl

3 min read

Judith-Data-Processing-Hacks

Mar 26

Pair and Transpose Adjacent Records within the Group - From SQL to SPL #13

#database #dataengineering #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 24

Calculate a Pair of Minimum Values that Meet the Criteria within the Group — From SQL to SPL #12

#sql #database #dataengineering #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 19

Calculate the Hierarchy of Recursive References — From SQL to SPL #11

#dataengineering #sql #esprocspl #database

2 min read

Judith-Data-Processing-Hacks

Mar 17

Calculate Monthly Account Balance and Fill in Missing Dates — From SQL to SPL #10

#dataengineering #database #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 12

Search for the Closest Matching Record within the Group — From SQL to SPL #9

#dataengineering #database #esprocspl #sql

2 min read

Judy

Mar 10

Get the records after and before the searched one：SQL VS SPL #12

#programming #devops #sql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 10

Calculate based on the records within the group and fill the result into the first record — From SQL to SPL #8

#sql #esprocspl #datascience #database

3 min read

Judith-Data-Processing-Hacks

Mar 5

Uncertain Number but Regular Column to Row Conversion — From SQL to SPL #7

#sql #dataengineering #opensource #esprocspl

2 min read

Judith-Data-Processing-Hacks

Mar 3

Align the existing data to the corresponding position and fill in any missing data with 0 — From SQL to SPL #6

#sql #opensource #mysql #esprocspl

2 min read

Judith-Data-Processing-Hacks

Feb 27

Flexible Interval Aggregation — From SQL to SPL #5

#sql #opensource #programming #esprocspl

2 min read

Judith-Data-Processing-Hacks

Feb 25

Convert Cross Cell to Row Header, Row Header to Column — From SQL to SPL #4

#opensource #sql #dataanalytics #esprocspl

2 min read

loading...