split_part(string text, delimiter text, field int)
Advertisements
Let us now check the split_part(string,delimiter,index) function with the following query.
Query
default> select split_part('tutorialspoint','t', 3) as split;
Result
The above query will generate the following result.
split ------------------------------- orialspoin
The split_part() method splits a string ‘tutorialspoint’ from the delimiter ’t’ with the index position 3. The result is “orialspoin”.
apache_tajo_string_functions.htm
Advertisements