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)

Reply via email to