You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Mehant Baid (JIRA)" <ji...@apache.org> on 2015/01/21 23:32:34 UTC
[jira] [Resolved] (DRILL-1727) REPEATED_CONTAINS sometimes doesn't
work
[ 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)