[
https://issues.apache.org/jira/browse/DRILL-1026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiao Meng updated DRILL-1026:
-----------------------------
Description:
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.
was:
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.
> 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
> Priority: Critical
> Labels: Metadata, Tableau
>
> 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.2#6252)
