[DRILL-1228] Connecting to Tableau live returns null values for dimensions

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.4.0
• Component/s: Client - ODBC
• Assignee: Unassigned
• Reporter: Norris Lee
• Created: 30/Jul/14 21:46
• Updated: 23/Apr/15 20:52
• Resolved: 31/Jul/14 05:53

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`

Issue Links

• Is contained by: DRILL-1231 SQL aliases does not work properly