DEV Community

Judy profile picture

Judy

Like open source, follow open source

Joined Joined on  Personal website https://github.com/SPLWare/esProc twitter website
Split a large csv file into smaller files #eg45
esproc_spl profile
Judy

Split a large csv file into smaller files #eg45

#csv #java #devops #spl
6
Comments
1 min read

Want to connect with Judy?

Create an account to connect with Judy. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Read specified columns from a csv file #eg44
esproc_spl profile
Judy

Read specified columns from a csv file #eg44

#csv #java #esproc #spl
5
Comments
1 min read
SQL, in each group modify the null value of a specified column as its neighboring value #eg43
esproc_spl profile
Judy

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

#sql #programming #esproc #java
7
Comments
1 min read
SQL, extract unique values of JSON format field from each group #eg42
esproc_spl profile
Judy

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

#sql #json #programming #esproc
10
Comments
2 min read
Parse a csv file having a primary-sub tables structure #eg41
esproc_spl profile
Judy

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

#learning #programming #beginners #esproc
6
Comments
2 min read
Add a compute column to a csv file #eg40
esproc_spl profile
Judy

Add a compute column to a csv file #eg40

#java #programming #devops #esproc
11
Comments
1 min read
Process a large csv file with parallel processing #eg39
esproc_spl profile
Judy

Process a large csv file with parallel processing #eg39

#java #programming #devops #opensource
11
Comments 1
1 min read
Compare large csv files #eg38
esproc_spl profile
Judy

Compare large csv files #eg38

#java #programming #devops #opensource
11
Comments 2
2 min read
Something could double the development efficiency of Java programmers
esproc_spl profile
Judy

Something could double the development efficiency of Java programmers

#java #programming #devops #esproc
7
Comments
6 min read
Split values of a field in a database table and transform it to new fields #eg37
esproc_spl profile
Judy

Split values of a field in a database table and transform it to new fields #eg37

6
Comments
1 min read
Get the whole group where at least one member meets the specified condition #eg36
esproc_spl profile
Judy

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

#sql #development #programming #esproc
6
Comments
2 min read
Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35
esproc_spl profile
Judy

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

#sql #development #programming #esproc
6
Comments
1 min read
Compare two csv files #eg34
esproc_spl profile
Judy

Compare two csv files #eg34

#sql #development #programming #esproc
7
Comments 1
1 min read
Java, perform COUNT on each group of a large csv file #eg33
esproc_spl profile
Judy

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

#sql #development #database #esproc
6
Comments
2 min read
Java, fill each row having a null value in a csv file with values in the directly previous row #eg32
esproc_spl profile
Judy

Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

#sql #development #programming #esproc
6
Comments
1 min read
To Index Data is To Sort Data
esproc_spl profile
Judy

To Index Data is To Sort Data

#sql #database #bigdata #esproc
8
Comments
5 min read
Group and Summarize data, and align to the specified sequence #eg31
esproc_spl profile
Judy

Group and Summarize data, and align to the specified sequence #eg31

#sql #development #programming #spl
6
Comments
1 min read
SQL, mark continuous rows with sequence numbers #eg30
esproc_spl profile
Judy

SQL, mark continuous rows with sequence numbers #eg30

#sql #development #programming #esproc
8
Comments
1 min read
SQL, compute cumulative sums according to the termination condition #eg29
esproc_spl profile
Judy

SQL, compute cumulative sums according to the termination condition #eg29

#sql #development #programming #esproc
7
Comments 1
1 min read
SQL, parse json data #eg28
esproc_spl profile
Judy

SQL, parse json data #eg28

#sql #development #programming #esproc
11
Comments
1 min read
SQL, concatenate multiple rows of strings and remove duplicates #eg27
esproc_spl profile
Judy

SQL, concatenate multiple rows of strings and remove duplicates #eg27

#sql #development #programming #esproc
8
Comments
1 min read
SQL, output associated records having many-to-many relationship row by row #eg26
esproc_spl profile
Judy

SQL, output associated records having many-to-many relationship row by row #eg26

#sql #development #programming #esproc
8
Comments
1 min read
Merge multiple files, remove duplicates and sort the result #eg25
esproc_spl profile
Judy

Merge multiple files, remove duplicates and sort the result #eg25

#sql #development #programming #esproc
6
Comments 1
1 min read
Clear duplicate lines and lines having missing values from a csv file #eg24
esproc_spl profile
Judy

Clear duplicate lines and lines having missing values from a csv file #eg24

#sql #programming #development #esproc
7
Comments 1
1 min read
Retrieve multiple columns from a csv file to generate a new file #eg23
esproc_spl profile
Judy

Retrieve multiple columns from a csv file to generate a new file #eg23

#softwaredevelopment #development #programming #esproc
7
Comments 1
1 min read
SQL, get historical status of each ID #eg22
esproc_spl profile
Judy

SQL, get historical status of each ID #eg22

#sql #development #programming #esproc
8
Comments 1
1 min read
SQL, get median of all columns in each row #eg21
esproc_spl profile
Judy

SQL, get median of all columns in each row #eg21

#sql #development #programming
9
Comments 1
1 min read
SQL, split values of two columns respectively and count members of their intersection #eg20
esproc_spl profile
Judy

SQL, split values of two columns respectively and count members of their intersection #eg20

#sql #development #programming
7
Comments 1
1 min read
SQL, Set different flags for different groups according to whether there are duplicate values #eg19
esproc_spl profile
Judy

SQL, Set different flags for different groups according to whether there are duplicate values #eg19

#sql #development #programming #esproc
8
Comments 1
1 min read
Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18
esproc_spl profile
Judy

Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18

#sql #development #programming #esproc
6
Comments 1
1 min read
Calculate the Average Interval of Projects for Each User #eg17
esproc_spl profile
Judy

Calculate the Average Interval of Projects for Each User #eg17

#sql #development #programming #esproc
8
Comments 1
1 min read
Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16
esproc_spl profile
Judy

Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16

#sql #development #programming #esproc
6
Comments 1
2 min read
Transpose Multiple Columns into One Row in Each Group #eg15
esproc_spl profile
Judy

Transpose Multiple Columns into One Row in Each Group #eg15

#sql #development #programming
6
Comments 1
1 min read
How to Combine Every Five Values into One Record #eg14
esproc_spl profile
Judy

How to Combine Every Five Values into One Record #eg14

#sql #development #programming
8
Comments 3
2 min read
Calculate the Total Price According to the Cumulative Price Table #eg13
esproc_spl profile
Judy

Calculate the Total Price According to the Cumulative Price Table #eg13

#sql #development #programming
6
Comments 1
1 min read
How to Parse Key-value Pairs from a Base64-encoded String in SQL?#eg12
esproc_spl profile
Judy

How to Parse Key-value Pairs from a Base64-encoded String in SQL?#eg12

#sql #development #beginners #programming
5
Comments 1
1 min read
How to Parse Key-value Pairs from a Base64-encoded String#eg11
esproc_spl profile
Judy

How to Parse Key-value Pairs from a Base64-encoded String#eg11

#sql #mysql
7
Comments 1
1 min read
Find All Top-level Folders from a List of Folders #eg10
esproc_spl profile
Judy

Find All Top-level Folders from a List of Folders #eg10

#folder #sql #softwaredevelopment #devops
7
Comments 1
1 min read
How to Display Dates Easily ? #eg9
esproc_spl profile
Judy

How to Display Dates Easily ? #eg9

#sql #development #esproc #puzzle
6
Comments 1
2 min read
Hadoop/Spark is too heavy, esProc SPL is light
esproc_spl profile
Judy

Hadoop/Spark is too heavy, esProc SPL is light

#hadoop #spark #heavy #development
8
Comments 1
12 min read
The impasse of SQL performance optimizing
esproc_spl profile
Judy

The impasse of SQL performance optimizing

#sql #programming #performance #spl
15
Comments 1
9 min read
How to Transpose Columns in Each Group to a Single Row
esproc_spl profile
Judy

How to Transpose Columns in Each Group to a Single Row

#sql #development #spl
12
Comments 1
2 min read
How the performance improvement by orders of magnitude happened
esproc_spl profile
Judy

How the performance improvement by orders of magnitude happened

#sql #database #property #spl
12
Comments 1
7 min read
A practical and easy to learn programming course
esproc_spl profile
Judy

A practical and easy to learn programming course

#cource #programming #beginners
10
Comments 1
2 min read
Data Calculation Problems Based on Object-Event Schema
esproc_spl profile
Judy

Data Calculation Problems Based on Object-Event Schema

#sql #development #programming #code
6
Comments 1
9 min read
File Performance Issues
esproc_spl profile
Judy

File Performance Issues

#file #issue #development #beginners
10
Comments 2
5 min read
Programming for Non-professionals
esproc_spl profile
Judy

Programming for Non-professionals

#books #programming #beginners
18
Comments 5
1 min read
The current Lakehouse is like a false proposition
esproc_spl profile
Judy

The current Lakehouse is like a false proposition

#lackhouse #bigdata #development #programming
6
Comments 1
10 min read
Is distributed technology the panacea for big data processing?
esproc_spl profile
Judy

Is distributed technology the panacea for big data processing?

#bigdata #processing #development #lauguage
7
Comments 1
10 min read
Which Scenarios Does ClickHouse Applies to?
esproc_spl profile
Judy

Which Scenarios Does ClickHouse Applies to?

#clickhouse #development #lauguage #beginners
7
Comments 1
5 min read
A data analysis engine reducing application cost by N times
esproc_spl profile
Judy

A data analysis engine reducing application cost by N times

#programming #beginners #devops #opensource
5
Comments 2
44 min read
A programming language coding in a grid
esproc_spl profile
Judy

A programming language coding in a grid

#sql #java #lauguage #development
9
Comments 1
17 min read
What kind of OLAP do we need？
esproc_spl profile
Judy

What kind of OLAP do we need？

#olap #sql #development #lauguage
5
Comments 1
5 min read
Then let’s talk about discreteness, and what are the advantages of Java over SQL?
esproc_spl profile
Judy

Then let’s talk about discreteness, and what are the advantages of Java over SQL?

#java #sql #development #lauguage
6
Comments 1
5 min read
Understanding set orientation from the comparison between SQL and Java, and what are the advantages of SQL over Java?
esproc_spl profile
Judy

Understanding set orientation from the comparison between SQL and Java, and what are the advantages of SQL over Java?

#java #sql #development #lauguage
6
Comments 1
5 min read
Order-based Merge Join
esproc_spl profile
Judy

Order-based Merge Join

#join #sql #development #language
5
Comments
6 min read
More foreign-key joins
esproc_spl profile
Judy

More foreign-key joins

#sql #join #development #opensource
6
Comments
5 min read
Foreign-key pre-join
esproc_spl profile
Judy

Foreign-key pre-join

#sql #join #development #lauguage
6
Comments
5 min read
Final association query solution
esproc_spl profile
Judy

Final association query solution

#sql #development #lauguage #spl
5
Comments
4 min read
Dimension alignment
esproc_spl profile
Judy

Dimension alignment

#sql #development #join #programming
5
Comments 1
4 min read
loading...