Rui Wang created BEAM-5952:
------------------------------
Summary: STARTS_WITH
Key: BEAM-5952
URL: https://issues.apache.org/jira/browse/BEAM-5952
Project: Beam
Issue Type: Sub-task
Components: dsl-sql
Reporter: Rui Wang
Assignee: Rui Wang
STARTS_WITH(value1, value2)
Takes two values. Returns TRUE if the second value is a prefix of the first.
Return type
BOOL
Examples
WITH items AS
(SELECT "foo" as item
UNION ALL
SELECT "bar" as item
UNION ALL
SELECT "baz" as item)
SELECT
STARTS_WITH(item, "b") as example
FROM items;
+---------+
| example |
+---------+
| False |
| True |
| True |
+---------+
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)