Articles by Tag #esproc
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Running SQL on files with the esProc is very convenient, on par with duckDB
esProc SPL, to query CSV, JSON, Excel and other files, you can use it directly after installation,...
Getting positions of members based on a specified condition #eg46
Find ordinal numbers of the student records in the Scores table where SCORE is 90 or above. SPL...
SQL, parse json data #eg28
In Google BigQuery database, data table stores a number of multilayer JSON strings. Below is one of...
Reverse Rows in a Text File #eg51
Problem description & analysis Below is text file txt.txt: abc 123 First line We are trying...
To Index Data is To Sort Data
Indexing is commonly used among programmers. Without fully grasping the idea behind the technique, a...
SQL, get historical status of each ID #eg22
In the sas system, table tab stores the patients’ medical history. Visit_code=Surgery means that the...
SQL, output associated records having many-to-many relationship row by row #eg26
Two database tables – Primary and Secondary – have same structure, where W, H and D are primary key...
Something Could Double the Development Efficiency of Java Programmers
Computing dilemma in the application Development and Framework, which should be given the...
SQL, Set different flags for different groups according to whether there are duplicate values #eg19
In MSSQL, my_table table has three columns (as shown below). Serial_Number is the grouping field; Id...
SQL, mark continuous rows with sequence numbers #eg30
In PostgreSQL database, tmp table has two grouping fields – source_id and event_user. Group the table...
Retrieve multiple columns from a csv file to generate a new file #eg23
I have a standard format csv file: I need to use Java to do this: Take column names as the...
Clear duplicate lines and lines having missing values from a csv file #eg24
In the csv file below, some lines have null values, some have NaN values, and there are duplicate...
Multi combination condition grouping and aggregation #eg93
The table in the MS SQL database is as follows, where id is the keyword: Now we need to first...
Compare two csv files #eg34
Here are two large, same-structure csv files A and B. Their primary keys are Name & Dept fields....
Split a Huge CSV File into Multiple Smaller CSV Files #eg69
Problem description & analysis Below is CSV file...
SQL, compute cumulative sums according to the termination condition #eg29
In MSSQL database, data table stores elevator operation records, where turn is the order of a person...
Something could double the development efficiency of Java programmers
Computing dilemma in the application Development and Framework, which should be given the higher...
SQL, in each group modify the null value of a specified column as its neighboring value #eg43
The following PostgreSQL database table is ordered by date field and company field. Some values of...
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...
Replace Duplicate Digits in Every 9-digit Number in a Text File with Non-duplicate Ones #eg52
Problem description & analysis Below is text file txt.txt: 853617639 975336865 The text file...
Data Analysis Showdown: Comparing SQL, Python, and esProc SPL
Talk is cheap; let’s show the codes. User Session Count User behavior data table A session is...
How to Speed Up COUNT DISTINCT with esProc
The COUNT DISTINCT in SQL has always been relatively slow. De-duplication is essentially a grouping...
Get the whole group where at least one member meets the specified condition #eg36
Below is a table queried from BigQuery database. Its 4th field has comma-separated strings. Use...
SQL, extract unique values of JSON format field from each group #eg42
Below is a table in PostgreSQL. Its 1st column contains IDs, according to which rows are ordered. The...
Add a compute column to a csv file #eg40
The csv file below stores assessment parameters: Use Java to do this: Compute Final Grade (the 4th...
SQL, concatenate multiple rows of strings and remove duplicates #eg27
The data table in MSSQL database stores flight connections. ID field is the group of connected...
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...
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...
Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35
Here is a csv file. Its 3rd column contains strings of a special format – they are enclosed by double...
Read specified columns from a csv file #eg44
Here is a standard format csv file: Use Java to do this: Use the specified multiple column numbers...