[jira] [Closed] (BEAM-5952) STARTS_WITH

["Rui Wang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rui Wang closed BEAM-5952.
--------------------------
       Resolution: Done
    Fix Version/s: Not applicable

> 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
>            Priority: Major
>             Fix For: Not applicable
>
>
> 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)