You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chris Matta (JIRA)" <ji...@apache.org> on 2015/01/09 18:49:35 UTC
[jira] [Updated] (DRILL-1973) Tableau query causes parsing error
[ https://issues.apache.org/jira/browse/DRILL-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Matta updated DRILL-1973:
-------------------------------
Description:
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}
was:
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}
> 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)