You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by 贺 峰 <he...@outlook.com> on 2018/10/13 07:04:08 UTC

Tableau connect hbase with Drill

hello

    I am glad to use Drill , but i get a problem
   when use tableau to connect hbase with drill  and sql like this

    select name from table group by name

    then  connect error






发送自 Outlook<http://aka.ms/weboutlook>

Re: Tableau connect hbase with Drill

Posted by Andries Engelbrecht <ae...@mapr.com>.
With Tableau and many BI Tools it is recommended that you use a Drill View. Also since HBase stores data in binary format you will need to use the convert or cast functions in Drill to convert the data types to something meaningful for these tools.

Make sure you can run the same query on the drillbit with sqlline. This way you are sure you have the correct path to the data/table and any syntax issues.

Regards

Andries 

> On Oct 13, 2018, at 12:04 AM, 贺 峰 <he...@outlook.com> wrote:
> 
> hello
> 
>    I am glad to use Drill , but i get a problem
>   when use tableau to connect hbase with drill  and sql like this
> 
>    select name from table group by name
> 
>    then  connect error
> 
> 
> 
> 
> 
> 
> 发送自 Outlook<https://urldefense.proofpoint.com/v2/url?u=http-3A__aka.ms_weboutlook&d=DwIGoQ&c=cskdkSMqhcnjZxdQVpwTXg&r=Q3Oz5l4W5TvDHNLpOqMYE2AgtKWFE937v89GEHyOVDU&m=KhYaFquMceYRoOpAkQViRYYTVYCwEY4nx2XaZNlCD1E&s=xonGpH3tz7PQGRsxKj2OT326RA6ucXVQjbZtrURGarw&e=>