substr(source text, start index, length)
Advertisements
Let us now check substr(string,start,length) with the following query.
Query
default> select substr('tutorialspoint',2,5) as substring;
Result
The above query will generate the following result.
substring ------------------------------- utori
The output returns the substring of (tutorialspoint,2,5) is utori. Here, 2 is the index position and 5 is the length.
apache_tajo_string_functions.htm
Advertisements