esProc SPL, to query CSV, JSON, Excel and other files, you can use it directly after installation, which is very convenient.

Query orders with sa

Running SQL on files with the esProc is very convenient, on par with duckDB

submited by

Style Pass

2025-01-27 03:00:05

esProc SPL, to query CSV, JSON, Excel and other files, you can use it directly after installation, which is very convenient. Query orders with sales volume greater than 1 from CSV:

The results of each step are saved in a cell, and the next step can be based on the above results to continue querying. For example, if you also want to calculate the sales of each product with a sales volume greater than 1:

Of course, a single SQL statement can also implement this task, but what if both of these results are what you want? What if we need to calculate the number of orders with a unit price of 100 or more in orders with sales volume greater than 1? Moreover, for some complex calculations, the excessively long SQL may appear blurry. With this ’ SQL step-by-step mechanism ’, it is easy to reuse and simplify calculations.

In addition to being used in IDEs, it also offer the JDBC driver and can be integrated in applications to serve as an embedded database.