drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1973) Tableau query causes parsing error
Date Sat, 28 Mar 2015 00:31:52 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384978#comment-14384978
] 

Steven Phillips commented on DRILL-1973:
----------------------------------------

Was this assigned to me for review?

If so, could you please mark as Reviewable?

> Tableau query causes parsing error
> ----------------------------------
>
>                 Key: DRILL-1973
>                 URL: https://issues.apache.org/jira/browse/DRILL-1973
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Relational Operators
>    Affects Versions: 0.7.0
>            Reporter: Chris Matta
>            Assignee: Steven Phillips
>             Fix For: 0.9.0
>
>         Attachments: 0001-DRILL-1973-Filter-should-check-for-record-count-befo.patch,
information_schema.views.txt
>
>
> Query:
> {code:sql}
> SELECT * FROM (
>     SELECT SUM(1) AS `sum_Number_of_Records_ok`
>     FROM `mfs.views`.`nestedclickview` `nestedclickview`
>     INNER JOIN `mfs.views`.`productview` `productview` ON (`nestedclickview`.`prod_id`
= `productview`.`prod_id`)
>     HAVING (COUNT(1) > 0)
> ) T LIMIT 0;
> {code}
> The views are from Andy P's Drill demo: https://github.com/andypern/drill-beta-demo.git
> productview is a view into a MapR-DB table, and nestedclickview is a view for nested
JSON data.
> I get the following error on the foreman:
> {code}
> 2015-01-09 16:08:43,042 [2b5002f4-cb62-1832-6331-ef89dbe2314b:foreman] ERROR o.a.drill.exec.work.foreman.Foreman
- Error e0
> 295344-2881-4a81-b739-0e20026b21b1: Query failed: Failure parsing SQL. Encountered ")"
at line 1, column 24.
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message