[
https://issues.apache.org/jira/browse/DRILL-1727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid resolved DRILL-1727.
--------------------------------
Resolution: Fixed
> REPEATED_CONTAINS sometimes doesn't work
> ----------------------------------------
>
> Key: DRILL-1727
> URL: https://issues.apache.org/jira/browse/DRILL-1727
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Tomer Shiran
> Assignee: Mehant Baid
> Fix For: 1.0.0
>
>
> Here are three queries. It seems that they should all work (the first is the
> most intuitive one), but only one of them does.
> {code}
> 0: jdbc:drill:zk=localhost:2181> SELECT name FROM
> dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json` WHERE
> REPEATED_CONTAINS(categories, 'Mediterranean') LIMIT 1;
> Query failed: Failure while running sql.
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> 0: jdbc:drill:zk=localhost:2181> SELECT name FROM
> dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json` WHERE true
> and REPEATED_CONTAINS(categories, 'Mediterranean') LIMIT 1;
> +------------+
> | name |
> +------------+
> | People's Bakery |
> +------------+
> 1 row selected (0.15 seconds)
> 0: jdbc:drill:zk=localhost:2181> SELECT name FROM
> dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json` WHERE 1 and
> REPEATED_CONTAINS(categories, 'Mediterranean') LIMIT 1;
> Query failed: Failure while running sql.
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
