incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob Rumsby <brum...@maprtech.com>
Subject Re: REPEATED_CONTAINS syntax
Date Thu, 20 Nov 2014 19:11:39 GMT
Hao,
Thanks for the information. I opened a new bug about wildcards, which don't
seem to work with this function. Let me know if you have had any success
with other ways to use this function, or if you have good examples to share.

Bob

On Tue, Nov 18, 2014 at 10:43 PM, Hao Zhu <hzhu@maprtech.com> wrote:

> a.json:
>
> {"data": ["apple","orange","abc"]}
>
> select repeated_count(data) from  dfs.tmp.`/drilltest/a.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> | 3          |
> +------------+
>
> select repeated_contains(data,'apple') from  dfs.tmp.`/drilltest/a.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> | true       |
> +------------+
>
> select repeated_contains(data,'nothing') from  dfs.tmp.`/drilltest/a.json`;
>
> +------------+
> |   EXPR$0   |
> +------------+
> | false      |
> +------------+
>
> Thanks,
> Hao
>
> On Tue, Nov 18, 2014 at 6:47 PM, Bob Rumsby <brumsby@maprtech.com> wrote:
>
> > Can someone provide some details on the signature and use of this
> function?
> > I'm not sure how/where it is supposed to work. It seems to work only as
> > part of a condition, but I'm not sure what the requirements are.
> >
> > (See https://issues.apache.org/jira/browse/DRILL-1727, opened by Tomer.)
> >
> > Thanks,
> > Bob
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message