[DRILL-1727] REPEATED_CONTAINS sometimes doesn't work

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Assignee: Mehant Baid
• Reporter: Tomer Shiran
• Created: 16/Nov/14 15:31
• Updated: 21/Jan/15 22:31
• Resolved: 21/Jan/15 22:31

Description

Here are three queries. It seems that they should all work (the first is the most intuitive one), but only one of them does.

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)