[
https://issues.apache.org/jira/browse/DRILL-1727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14238662#comment-14238662
]
Venkata krishnan Sowrirajan commented on DRILL-1727:
----------------------------------------------------
In this, the first 2 queries (1 & 2) are working fine for me with the latest
build.
For the 3rd query, I am getting an Error saying
"org.eigenbase.sql.validate.SqlValidatorException: Cannot apply 'AND' to
arguments of type '<INTEGER> AND <BOOLEAN>'. Supported form(s): '<BOOLEAN> AND
<BOOLEAN>". Here I think Drill should take "1" or "0" as boolean value to
handle these kind of queries.
> 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
> Fix For: 0.9.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)
