[
https://issues.apache.org/jira/browse/DRILL-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14273715#comment-14273715
]
Chris Matta commented on DRILL-1973:
------------------------------------
Vicky,
I'm trying to narrow this down... The query above returns correct when run from
sqlline (after shutting down all drillbits, and starting them again), however
when trying to run it from the ODBC Drill Explorer (0.07.0.0608 64bit) I get
the following error:
{code}
ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: 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
[30024]Query execution error. Details:[
Query failed: Failure while running fragment., Attempted to close accountor
with 1 buffer(s) still allocatedfor QueryId:
2b4c115f-4e82-a2df-c71c-1332d7e3ea3d, MajorFragmentId: 1, MinorFragmentId: 11.
Total 1 allocation(s) of byte size(s): 3484, at stack location:
org.apache.drill.exec.memory.TopLevelAllocator$ChildAllocator.takeOwnership(TopLevelAllocator.java:192)
org.apache.drill.exec.rpc.data.DataServer.handle(DataServer.java:119)
org.apache.drill.exec.rpc.data.DataServer.handle(DataServer.java:48)
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:194)
org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:173)
io.n...
{code}
> Tableau query causes parsing error
> ----------------------------------
>
> Key: DRILL-1973
> URL: https://issues.apache.org/jira/browse/DRILL-1973
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Affects Versions: 0.7.0
> Reporter: Chris Matta
> Assignee: Aman Sinha
>
> 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)
