Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1973

Tableau query causes parsing error

    XMLWordPrintableJSON

Details

    Description

      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 LIMIT 0;
      

      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:

      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.
      

      Attachments

        Activity

          People

            sphillips Steven Phillips
            cmatta Chris Matta
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: