Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1026

Tableau generated metadata query does not return metadata for multi-region HBase table

    Details

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                xiaom Xiao Meng
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: