Hive tables are not available in tableau

0 votes

I have created a table, ztest7 in the default database in my hive. I am able to query it using beeline. In tableau, I can query it using a custom SQL.

However, the table does NOT show when I search for it.

enter image description here

Am I missing something here?

Tableau Desktop Version = v10.1.1  
Hive = v2.0.1  
Spark = v2.1.0

Jun 27, 2018 in Tableau by ffdfd
• 5,550 points
1,388 views

1 answer to this question.

0 votes

I have the same issue with Tableau Desktop 10 (mac) to Hive (2.1.1) via Spark SQL 2.1 (on centos 7 server) This is what I got from Tableau support team:

In Tableau Desktop, the ability to connect to Spark SQL without a defining a default schema is not currently built into the product.

As a preliminary step, to define a default schema, configure the Spark SQL hivemetastore to utilize a SchemaRDD or DataFrame. This must be defined in the Hive Metastore for Tableau Desktop to be able to access it. Pure schema-less Spark RDD's can not be queried by Spark SQL because of the lack of a schema. RDDs can be converted into SchemaRDDs, which have additional schema metadata as Spark SQL provides access to SchemaRDDs. When a SchemaRDD is created, it is only available in the local namespace or context, and is unavailable to external services accessing Spark through ODBC and the Spark Thrift Server. For Tableau to have access, the SchemaRDD needs to be registered in a catalog that is available outside of just the local context; the Hive Metastore is currently the only supported service.

answered Jun 27, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
1 answer

In Tableau, how to pass measure/dimension to action filters that are not in the chart?

Hi Sindhu,  You can choose the fields that are ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
5,409 views
0 votes
1 answer

How interactive graphs are generated in Tableau?

Lot of back end code is shared ...READ MORE

answered Apr 14, 2018 in Tableau by xyz
• 1,560 points
688 views
0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in the ...READ MORE

answered May 17, 2018 in Tableau by Mathew1810
1,358 views
0 votes
1 answer

Not able to publish workbook in Tableau Server after upgrading it from Tableau 9.1 to 9.2

Following is a little hack that will ...READ MORE

answered Jun 19, 2018 in Tableau by xyz
• 1,560 points
1,077 views
+1 vote
2 answers
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
10,910 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
2,443 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
108,228 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,749 views
0 votes
1 answer

How can I count the aggregate function in Tableau

Create two calculated fields one for 100's ...READ MORE

answered Apr 6, 2018 in Tableau by Atul
• 10,240 points
5,551 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP