Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to use SQL to query TXT in Java. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Java can not directly use SQL to query the text, the general practice is to create a temporary table in the database, Java parse the text into the database, and then use SQL to query, filter, group and so on.

But the implementation process is too troublesome. The main inconveniences are as follows:

1. Java code is very long to write, and the configuration of the development environment is complex, which generally requires high personnel.

2. In order to obtain the convenience of SQL, it is not difficult to install databases and create temporary tables, but it is tedious.

3. Some temporary and sudden requirements take a long time, and even if the database is not allowed to be installed in some scenarios, it is very embarrassing. It is difficult to write all in Java.

For example, to deal with such a scenario: for an order with an amount greater than 10000 after querying 1996-07-23, some of the source data are as follows:

O_ORDERKEY O_CUSTKEY O_ORDERDATE O_TOTALPRICE

10262 RATTC 1996-07-22 14487.0

10263 ERNSH 1996-07-23 43818.0

10264 FOLKO 2007-07-24 1101.0

10265 BLONP 1996-07-25 5528.0

10266 WARTH 1996-07-26 7719.0

10267 FRANK 1996-07-29 20858.0

10268 GROSR 1996-07-30 19887.0

10269 WHITC 1996-07-31 456.0

10270 WARTH 1996-08-01 13654.0

...

Expected results:

It is much easier to use the aggregator SPL, which directly provides SQL-style query and computing capabilities for files (txt, Excel, etc.), allowing programmers to enjoy absolute convenience and stop thinking about these troubles. For example, the above question is solved in one line:

A

one

$() select * from / workspace/orders.txt where O_ORDERDATE > = date ('1996-07-23') and O_TOTALPRICE > 10000

On how to use SQL query TXT in Java to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.