Uploaded image for project: 'Search and Discovery'
  1. Search and Discovery
  2. SEARCH-1824

Queries including count(*) do not work with tableau

    Details

      Description

      Setup:
      ACS + Insight Engine (say, 1.4)
      Also create a ODBC connection using CDATA driver.

      Steps:
      1. Using this ODBC connection as DSN, run the following query in Excel

      Query: select SITE, count(*) from alfresco group by Site
      

      2. Run the same query using Tableau,
      The following error is returned.
      Unable to execute the query, error caused by: Unknown field '*'.

      Stacktrace:

      Unable to complete action
      [400] 07210012 Unable to execute the query, error caused by: Unknown field '*'. 
      An error occurred while loading the data.
      [400] 07210014 Unable to execute the query, error caused by: Unknown field '*'.
      SELECT TOP 10000 `TableauSQL`.`SITE` AS `SITE`,
        `TableauSQL`.`count_42` AS `count_42`
      FROM (
        select SITE, count(*) from alfresco
      ) `TableauSQL`
      
      

      The issue does not seem to be qith CDATA driver as with excel, it returns the results.
      Considering tools like Tableau provide working with measures and functions such as count(field) count, tried to change the query to:
      select SITE, cm_name, `cm:content.size` from alfresco
      in order to build the dashboard using Tableau features.

      But 2 issues were seen:
      1. count(field) isn't supported for Insight Engine hence an error is shown
      2. count shows up as null

      In order to support BI tools like Tableau, support for the count functions may be required.

        Attachments

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  mbhave Meenal Bhave [X] (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel