-
jinxing • Application • 36 View • 2025-03-27 18:51:57
From SQL to SPL: Converting JSON data to Tabular in Snowflake
-
jinxing • esProc • 106 View • 2025-04-23 11:41:42
How to simplify nested SQL in applications with esProc
-
jinxing • esProc • 334 View • 2025-04-23 11:41:19
How to query CSV as a database table in Java with esProc
-
-
jinxing • Application • 50 View • 2025-03-18 18:09:14
From SQL to SPL: Segmented accumulation by condition
-
jinxing • Application • 57 View • 2025-03-17 16:43:25
From SQL to SPL: Generate calculated columns based on continuous values
-
-
-
-
jinxing • Application • 64 View • 2025-03-12 14:04:02
From SQL to SPL: Find consecutive alphabetical characters in string
-
jinxing • Application • 54 View • 2025-03-11 17:00:59
From SQL to SPL: Aggregate according to time interval
-
jinxing • Application • 69 View • 2025-03-10 17:08:42
From SQL to SPL：Create columns from distinct values of a column
-
jinxing • Application • 55 View • 2025-05-07 09:47:52
From SQL to SPL: Substring from a column of strings
-
jinxing • Application • 79 View • 2025-03-04 17:30:53
From SQL to SPL: Fetch values from previous non-null value rows
-
-
jinxing • Application • 64 View • 2025-02-27 17:26:20
From SQL to SPL: Summarize row counts by dynamic columns into json
-
jinxing • Application • 67 View • 2025-02-26 22:34:43
From SQL to SPL: Deduplicate between an uncertain number of columns
-
jinxing • Application • 69 View • 2025-02-25 17:39:05
From SQL to SPL: Find the closest date match for each record from two tables
-
jinxing • Application • 59 View • 2025-02-20 17:28:34
From SQL to SPL: Find the superset from the relationship table
-
jinxing • Application • 58 View • 2025-02-19 17:46:57
From SQL to SPL: Get the records after and before the searched one
-
sjr • esProc • 57 View • 2025-02-17 20:07:18
esProc uses simple SQL queries on structured text files
-
sjr • esProc • 57 View • 2025-02-17 19:09:05
Conventional operations of esProc SPL on structured text files
-
jinxing • Application • 64 View • 2025-02-17 09:07:48
From SQL to SPL: Do ordered grouping and aggregation within groups
-
-
jinxing • Application • 179 View • 2025-02-17 09:18:17
From SQL to SPL: Track Production Operations Outcome Progression with Conditional NULLs