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

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Client - ODBC
• Labels: Metadata Tableau
• Assignee: Unassigned
• Reporter: Xiaomeng Huang
• Created: 19/Jun/14 17:17
• Updated: 23/Apr/15 21:58
• Resolved: 26/Jun/14 01:10

Description

Observed from the driver's log (June 16), when running the following custom SQL

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

Tableau will generate the following query

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)

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.

Issue Links

• is related to: DRILL-884 Query used to derive result set metadata for Tableau's "Custom SQL" does not run