Krystal created DRILL-1041:
------------------------------
Summary: 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
--
This message was sent by Atlassian JIRA
(v6.2#6252)
