HPL/SQL is included to Apache Hive since version 2.0
Sidebar
substring
SUBSTRING Function - PL/HQL Reference
SUBSTRING function returns a substring from string.
Syntax:
SUBSTRING(string, start_pos [, substring_len]) | SUBSTRING(string FROM start_pos [FOR substring_len])
Parameters:
| Parameter | Type | Value | Description |
| string | String | Variable or expression | Original string |
| start_pos | Integer | Variable or expression | Start position of substring (starts from 1) |
| substring_len | Integer | Variable or expression | Length of substring |
Notes:
- If start_pos is 0 then it is treated as 1
- SUBSTRING and SUBSTR functions are synonyms
Return Type:
String.
Example:
SUBSTRING('Remark', 3);
Result: 'mark'
Example:
SUBSTRING('Remark', 3, 3);
Result: 'mar'
Compatibility: IBM DB2, Teradata and Microsoft SQL Server.
See also:
Version:
- PL/HQL 0.3.11 SUBSTRING FROM FOR syntax added
- PL/HQL 0.01 introduced
Page Tools
