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=>