[
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)
