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

Re: Tableau connect hbase with Drill

[Andries Engelbrecht]

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, 贺 峰  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