You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Xiao Meng (JIRA)" <ji...@apache.org> on 2014/06/19 19:18:25 UTC
[jira] [Created] (DRILL-1026) Tableau generated metadata query does
not return metadata for multi-region HBase table
Xiao Meng created DRILL-1026:
--------------------------------
Summary: 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
Reporter: Xiao Meng
Observed from the driver's log, 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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)