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

How to use merge fields in XSTAR to solve the problem of date and time division storage, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

It looks concatenated, but there is also a comma separator in the middle, so it becomes two fields, and XSTAR requires the time and date in one field!

To this end, we have added a new tool to the toolbox to merge fields!

As follows:

Select the two fields and click "merge" to complete the merge of the two selected fields, as follows:

The values of the two blue areas are merged into the values of the red area, with a space between the two values. The merged file will be stored in a new file, obviously, the file size will be a little larger!

Then, you can process the data as usual!

Like this, generate a field description:

Extract field identity:

Sort data:

It is important to note that the time span is set. You need to select the appropriate time span according to the needs of the analysis. This parameter needs to match the time granularity of the following indexing:

Because the time span of this data is very large, more than ten years, so when analyzing, it is necessary to set the analysis time span according to the analysis purpose (optional start and end time when sorting) and time granularity (selected when indexing). Obviously, if the analysis time is 10 years and the granularity is 1 second, then the amount of data will be too large. If you are analyzing a few of these days, setting seconds to granularity is more or less the same.

When we set up the index this time, the time granularity is set to hours, that is, 3600 seconds!

It took almost 4 minutes to complete the index construction, although it takes a long time, but the file is very small, only 8MB, can be opened with time analysis.

As can be seen from the animation, there are some very fixed commuters, such as No. 128, who live near Huilongguan and work in Zhongguancun.

Welcome to download and try!

Software acquisition method

At the bottom of this article, click "like the author", and pay any amount of fee (do not customize the amount, engineers do not need an amazing amount), after that, the software download address will be automatically sent through the official account of Wechat.

Follow the official account "big data engineer".

In the official account, enter "xstar" to get the software authorization code

To download the software and run it for the first time, you need to give the registration information, as follows:

!!! In addition to software downloads, you may also see rare sample data in the download folder > 10GB

The purpose and explanation of the paid use of the software

Confirm that Lion Friends is a serious user of software tools.

Partly bear the cost of network storage and distribution of software tools.

This fee is not the cost of software purchase, so the engineer has no obligation to guarantee that the software will work properly, but Lion friend's suggestion or suggestion will be carefully considered by the engineer.

Software tools may be deactivated for any reason, and the engineer has no responsibility or obligation to explain.

This is the answer to the question about how to use merge fields to solve the problem of date and time division storage in XSTAR. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.