hive locate

Hive's `LOCATE` function is used to find the position of a substring within a given string. It returns the starting index (1-based) of the substring within the string, or 0 if the substring is not found. The syntax for using `LOCATE` in Hive is as follows:

LOCATE(substring, string [, start_position])

- `substring`: The substring you want to search for within the string.
- `string`: The string in which you want to find the substring.
- `start_position` (optional): The starting position from where the search should begin. If not specified, the search starts from the beginning of the string.

Here's an example:

SELECT LOCATE('world', 'Hello world') AS position;

This will return `7`, indicating that the substring 'world' starts at position 7 in the string 'Hello world'.