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

Connecting to Tableau live returns null values for dimensions

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 0.4.0
    • Fix Version/s: 0.4.0
    • Component/s: Client - ODBC
    • Labels:
      None

      Description

      Connecting to Tableau using live queries returns null dimensions. Connecting using Import All will return as normal. Both queries run fine in SQLLine and Drill Explorer. Using an older drillbit (from July 21st), everything ran fine.

      Live query:

      SELECT `varchar_table`.`column1` AS `none_columnB_nk`
      FROM `hive43.default`.`varchar_table` `varchar_table`
      GROUP BY `varchar_table`.`column1`
      

      Import All query:

      SELECT 1 AS `Number_of_Records`,
        `varchar_table`.`column1` AS `columnB`,
        `varchar_table`.`keycolumn` AS `keycolumn`
      FROM `hive43.default`.`varchar_table` `varchar_table`
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                norrisl Norris Lee
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: