You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/06/20 02:02:24 UTC

[jira] [Created] (DRILL-1041) Drill should ignore "group by" issued from odbc for hbase tables in tableau

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)