Drill Tableau Live connection issue

[Divya Gehlot]

Hi,
I am facing a strange issue with Tableau Apache Drill live connection
Tableau Version : 10.4
MapR Drill Driver : MapRDrill_odbc_v1.3.13.1037
OS : Windows Server 2012

I have few numeric values in the view I connected and When I describe it I
get
"The Single value is null" even for all the computation using that field
When I create the extract with the same connection , It all works fine

If any body uses Tableau for Drill Visualisation ,Appreciate the help !

Thanks,
Divya

[Andries Engelbrecht]

What version of Drill are you using?

I would recommend using ODBC v1.3.16

Did you define data types in your view? Tableau with the ODBC driver may use the execution of a LIMIT 0 query when trying to collect metadata, with a poorly defined view it can potentially cause issues pending the underlying data.





Andries Engelbrecht
Senior Solution Architect
Alliances and Channels Engineering
MapR

Post by Divya Gehlot
Hi,
I am facing a strange issue with Tableau Apache Drill live connection
Tableau Version : 10.4
MapR Drill Driver : MapRDrill_odbc_v1.3.13.1037
OS : Windows Server 2012
I have few numeric values in the view I connected and When I describe it I
get
"The Single value is null" even for all the computation using that field
When I create the extract with the same connection , It all works fine
If any body uses Tableau for Drill Visualisation ,Appreciate the help !
Thanks,
Divya

[Divya Gehlot]

I am using Drill 1.10
I am using custom query with column casting in Tableau.
With Drill driver ODBC v1.3.16 I am getting handshake failure for Active
directory users whereas with local OS user I am able to connect .

Thanks,
Divya

Post by Andries Engelbrecht
What version of Drill are you using?
I would recommend using ODBC v1.3.16
Did you define data types in your view? Tableau with the ODBC driver may
use the execution of a LIMIT 0 query when trying to collect metadata, with
a poorly defined view it can potentially cause issues pending the
underlying data.
Andries Engelbrecht
Senior Solution Architect
Alliances and Channels Engineering
MapR
Hi,
I am facing a strange issue with Tableau Apache Drill live connection
Tableau Version : 10.4
MapR Drill Driver : MapRDrill_odbc_v1.3.13.1037
OS : Windows Server 2012
I have few numeric values in the view I connected and When I describe it I
get
"The Single value is null" even for all the computation using that field
When I create the extract with the same connection , It all works fine
If any body uses Tableau for Drill Visualisation ,Appreciate the help !
Thanks,
Divya