Hive SQL Split delimiter

Hive string splitting function

Split (str, regex)-splits str around occurances that match regex
Time taken:0.769 seconds, fetched:1 row (s)

The return value is an array

A. Basic usage :

Example 1:

Split (' A,b,c,d ', ', ')

The results obtained:

["A", "B", "C", "D"]

B. Intercept a value in a string:

Of course, we can also specify an item in the result array

Example 2:

Split (' A,b,c,d ', ', ') [0]

The results obtained:

A

C. Handling of special characters:

Special split symbol

Regex is a string-matching parameter, so special handling is required when encountering special characters

Example 3: "." Point

Split (' 192.168.0.1 ', '. ')

The results obtained:

[]

The correct wording:

Split (' 192.168.0.1 ', ' \ \ ')

The results obtained:

["192", "168", "0", "1"]

It is important to note that:

Of course, when split is included in the "", you need to add 4 additional \

such as Hive-e ".... Split (' 192.168.0.1 ', ' \\\\. ') ... "Otherwise the resulting value is null

The same | Such special symbols also need to be handled similarly.

Hive SQL Split delimiter