[jira] [Closed] (DRILL-1026) Tableau generated metadata query does not return metadata for multi-region HBase table

["Krystal (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Krystal closed DRILL-1026.
--------------------------

Verified that bug is fixed.  Test case at:
resources/Functional/Passing/odbc/hbase/select_all.q

> Tableau generated metadata query does not return metadata for  multi-region HBase table
> ---------------------------------------------------------------------------------------
>
>                 Key: DRILL-1026
>                 URL: https://issues.apache.org/jira/browse/DRILL-1026
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - ODBC
>            Reporter: Xiao Meng
>            Priority: Critical
>              Labels: Metadata, Tableau
>             Fix For: 0.4.0
>
>
> Observed from the driver's log (June 16), when running the following custom SQL
> {code}
> select 
> cast(row_key as integer) voter_id,
> cast(onecf['name'] as varchar(30)) name,
> cast(twocf['age'] as integer) age, 
> cast(twocf['registration'] as varchar(20)) registration, 
> cast(threecf['contributions'] as decimal(6,2)) contributions, cast(threecf['voterzone'] as integer) voterzone,
> cast(fourcf['create_date'] as timestamp) create_date from hbase.voter
> {code}
> Tableau will generate the following query
> {code}
> SELECT *
> FROM (
>   select cast(row_key as integer) voter_id,cast(onecf['name'] as varchar(30)) name,cast(twocf['age'] as integer) age, cast(twocf['registration'] as varchar(20)) registration, cast(threecf['contributions'] as decimal(6,2)) contributions, cast(threecf['voterzone'] as integer) voterzone,cast(fourcf['create_date'] as timestamp) create_date from hbase.voter
> ) `TableauSQL`
> WHERE (0 = 1)
> {code}
> In the case of HBase table resident in one region, it will return expected metadata.
> But in the case of multi-region HBase table, it will return no metadata.
> *Updated:* 
> Now, the above query will fail  both for single-region and multi-region HBase table. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)