[jira] [Created] (DRILL-1973) Tableau query causes parsing error

["Chris Matta (JIRA)" <ji...@apache.org>]

Chris Matta created DRILL-1973:
----------------------------------

             Summary: 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)