[
https://issues.apache.org/jira/browse/DRILL-1041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Neeraja updated DRILL-1041:
---------------------------
Assignee: Krystal (was: Neeraja)
> Drill should ignore "group by" issued from odbc for hbase tables in tableau
> ---------------------------------------------------------------------------
>
> Key: DRILL-1041
> URL: https://issues.apache.org/jira/browse/DRILL-1041
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - ODBC
> Environment: git.commit.id.abbrev=894037a
> In tableau, when I connect to an hbase table and drag the column families to
> create charts, I got the following error:
> [MapR][Drill] (1040) Drill failed to execute the query: SELECT
> `voter`.`onecf` AS `none_onecf_nk`
> FROM `hbase`.`voter` `voter`
> GROUP BY `voter`.`onecf`
> [23]Query execution error. Details:[
> Failure while running fragment. < UnsupportedOperationException
> ]
> The same sql failed in sqlline due to the "group by" clause against column
> family. The suggestion from the Simba team is for drill to ignore the "group
> by" in this case.
> The work around for this problem is to create a view against the hbase table
> and use the view with tableau.
> Reporter: Krystal
> Assignee: Krystal
>
--
This message was sent by Atlassian JIRA
(v6.2#6252)
