drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1041) Drill should ignore "group by" issued from odbc for hbase tables in tableau
Date Fri, 25 Jul 2014 16:02:40 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1041?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14074504#comment-14074504

Krystal commented on DRILL-1041:

I moved the column families to fact/measures.  Under this section, tableau uses count() against
the selected column family.  However, this failed because drill currently does not support
count() against column family.  I have opened the following jira for this issue: https://issues.apache.org/jira/browse/DRILL-1174

> 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: Neeraja

This message was sent by Atlassian JIRA

View raw message