drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hanifi Gunes (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1729) Exception when selecting more fields
Date Fri, 28 Nov 2014 20:31:12 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hanifi Gunes updated DRILL-1729:
--------------------------------
    Attachment: DRILL-1729.1.patch.txt

derive & infer result type for boolean returning custom functions so that optiq can validate
and execute user queries


> Exception when selecting more fields
> ------------------------------------
>
>                 Key: DRILL-1729
>                 URL: https://issues.apache.org/jira/browse/DRILL-1729
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Tomer Shiran
>            Assignee: Aman Sinha
>             Fix For: 0.7.0
>
>         Attachments: DRILL-1729.1.patch.txt
>
>
> The first query here works, while the second doesn't. The only difference is another
field added to the SELECT.
> {code}
> 0: jdbc:drill:zk=localhost:2181> SELECT name, categories FROM dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json`
WHERE true and REPEATED_CONTAINS(categories, 'Australian');
> 	+------------+------------+
> 	|    name    | categories |
> 	+------------+------------+
> 	| The Australian AZ | ["Bars","Burgers","Nightlife","Australian","Sports Bars","Restaurants"]
|
> 	+------------+------------+
> 	1 row selected (3.068 seconds)
> 	0: jdbc:drill:zk=localhost:2181> SELECT business_id, name, categories FROM dfs.root.`Users/tshiran/Development/demo/data/yelp/business.json`
WHERE true and REPEATED_CONTAINS(categories, 'Australian');
> 	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)

Mime
View raw message